| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Response Time | Excel Discussion (Misc queries) | |||
| calculating time | Excel Discussion (Misc queries) | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Linear Mode
