time diffrence with 24 hour clock

R

Rich Mcc

can you tell me the formula for telling the time diffrence between 2 times
when the either time may appear after midnight, without the need for a 48hr
clock

time due - 23:00 time arrived - 01:00 (2 hours)
time due - 01:00 time arrived - 23:00 (blank) but using a 24 hr clock this
shows as 22 ours late when in fact is 2 hours early

thanks
 
D

David Biddulph

You'll either have to tell it the date as well as the time, or you're going
to have to decide where you draw the line between something being late for
one day and being early for the following day.

You could draw that line at 12 hours.
=MOD(B1-A1+0.5,1)-0.5

To display negative times you may have to use the 1904 date system (Tools/
Options/ Calculation)
 
S

SteveW

Just, assuming 2 times First and Last and no dates

=if( Last>First, Last-First, 1+First-Last)

Steve
 

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

Subtracting time...again 2
separating date and time 5
Time Zone Conversion Table 1
TIME CALCULATION 8
Showing 24 hour time along X-axis 0
Over time? 4
15 minute data to daily data 1
Add time when working 3rd shift 0

Top