ExcelBanter - How do I get Exel to return # of hrs. worked, start time is enter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I get Exel to return # of hrs. worked, start time is enter (https://www.excelbanter.com/excel-worksheet-functions/63075-how-do-i-get-exel-return-hrs-worked-start-time-enter.html)

joyce007

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

Vito

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

All times are GMT +1. The time now is 10:46 AM.