Calculating Time
 

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


--
Padovan
------------------------------------------------------------------------
Padovan's Profile: http://www.excelforum.com/member.php...o&userid=26432
View this thread: http://www.excelforum.com/showthread...hreadid=552490

Calculating Time
 

Try:

=B1-A1+(B1<A1)

or

=MOD(B1-A1,1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Padovan" wrote in
message ...

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


--
Padovan
------------------------------------------------------------------------
Padovan's Profile:
http://www.excelforum.com/member.php...o&userid=26432
View this thread: http://www.excelforum.com/showthread...hreadid=552490

Calculating Time
 

Padovan,

Try this formula instead:

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

Hope that helps!

Steph


"Padovan" wrote:


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


--
Padovan
------------------------------------------------------------------------
Padovan's Profile: http://www.excelforum.com/member.php...o&userid=26432
View this thread: http://www.excelforum.com/showthread...hreadid=552490

Calculating Time
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Padovan" wrote in
message ...

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


--
Padovan
------------------------------------------------------------------------
Padovan's Profile:
http://www.excelforum.com/member.php...o&userid=26432
View this thread: http://www.excelforum.com/showthread...hreadid=552490

Calculating Time
 

"Padovan" wrote in
message ...

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.
--
David Biddulph