Calculating Time

P

Padovan

I need help figuring out a simple function (Work Start Time - Clock In
Time) = hours or minutes late

I tried...
B1-A1 = C1
8:40am - 9:00am = 23:40

I'm obviously missing something...please help!!
 
S

Stephanie Aspinwall

Padovan,

Try this formula instead:

=TEXT((B1-A1),"h:mm")

Hope that helps!

Steph
 
B

Bernard Liengme

I assume these are one day apart.
Excel keeps data/time as a serial number in days, so all that is wrong is
the display format
Format you cell [h]:mm
The brackets are to allow more that 12 hours
best wishes
 
D

David Biddulph

Padovan said:
I need help figuring out a simple function (Work Start Time - Clock In
Time) = hours or minutes late

I tried...
B1-A1 = C1
8:40am - 9:00am = 23:40

I'm obviously missing something...please help!!
Click to expand...

If you want it to be able to display negative time differences, then try:
Tools/ Options/ Calculation
and select 1904 date system.
 
Top