Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Exel to return # of hrs. worked, start time is enter
In our timesheet, we enter start time and end time. How do I get Excel to
return # of hrs. worked? If is use: (d11-c11) a decimal fraction is returned. ie. .21 for 8:00 am to 1:pm. How do I get it to return 5 hrs.? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Exel to return # of hrs. worked, start time is enter
Format the cell as Custom|h:mm -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=497918 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
start up exel errors | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
time format multiplied by hours worked ? | Excel Worksheet Functions | |||
The shortcut to enter time in excel should include seconds. | Excel Discussion (Misc queries) |