Calculating Time

[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!!

 

[Sandy Mann]

Try:

=B1-A1+(B1<A1)

or

=MOD(B1-A1,1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Padovan,

Try this formula instead:

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

Hope that helps!

Steph

 

[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

 

[David Biddulph]

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!!

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