THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

Excel question

Matt_was_taken [Edit] [Delete] 13:36, 24 January '13

I have a column of data, it has to be in the format hh:mm ddd
so looks like 13:30 Mon and so on.
in the column next to it I want to have this value minus 30 mins
so looks like 13:00 Mon and so on.
how do I do this please?
cheers