advanced excel seminar training - Negative time

it must be 08:44-08:30 not 08:30-08:44

Ali,

There are several ways around this. As they can be fairly technical, and specific to what you are looking for, I'd rather not just retype them all below in an attempt to seem intelligent. So here is a way for you to get what you want:

Search for the following in Google:

excel negative time

have a look at how several of the solutions have been created. one of them should fit for you.

Let me know how you get on.

Hope you enjoyed your Microsoft Excel training the other day.

Richard

Hi Alistair,

Try this one, (Use your format in all the active cells but just use one h in square brackets to show the 24 hour format, in Format Cells, Number, Custom remove any reference to :ss for seconds.)
To fix your problem you will need to use an IF function to add a day to the minus time if it is necessary.
Probably easier if I put in the formula so that I can explain it for you...
My start time is in B5 and my end time is in C5, my start time is for example 20:00 and my end time the following day at 02:00, Excel will consider that I have started after I finished, (not good) however adding an extra day to your formula will allow Excel to provide you with the correct period of working. The formula which will provide you with a correct answer in cell C7 (for example) should read as follows: select C7 and enter =IF(C5<B5,C5+1-B5,C5-B5)you can then copy this formula to other cells if necessary.