adding TIME through midnight calculates ok, but subtract doesn't

S

skipper

on a worksheet of timings, adding TIME through midnight calculates ok, but
subtracting time through midnight results in an error - any ideas on sorting
this?
 
M

Mike H

Hi,

Use this general formula for tiimes spanning midnight and for thos that don't

=(B1-A1+(B1<A1))*24


Mike
 

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
Averaging times that cross midnight? 4
TIME CALCULATION 8
Time calculations over 24hrs 8
How do I calc the time difference in hh:mm for shift work? 12
time clock wrap around 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

Top