time clock wrap around midnight

B

BillO

Hi

For example I have two times entered as 23:30 and 1:45 (but the next day) we
are not entering the date just the time. Subtracting the two gets the
correct answer but when the times wrap around midnight (as above) then there
is a negative time difference and it is wrong.

How can I keep entering just the basic time (without date) and take the
difference and make this difference work around midnight?

thanks
 
P

Peo Sjoblom

With start time in A1 and end time in B1


=B1-A1+(B1<A1)

or

=MOD(B1-A1,2)

don't forget to format result as time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula than understands midnight? 26
single cell time entry as time - time; Ever seen this? 12
IF statement with time over midnight 3
Date/Time Calculation past midnight...help - Microsoft Access 1
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
How Can I subtract from time within a 24 hour clock? 3
formula to calculate time difference crossing midnight 3
How to Subtract times on 24hour clock and avoid error message in . 5

Top