I am trying to create a timesheet in excel that will take and entry of say 8:00 a.m. in one cell and 5:00 p.m. in another cell and give a total number of hours for my employee... I know this is probably simple for you all - but help!!!
Thanks
I've got a pretty good time sheet spread sheet. I'm not sure where i got it from, but theres a macro in it recorded by John Walkenbach, so he gets the credit. Post your email if you'd like it
Hi bgoodell and brettvba:
Let us say you enter your start and end time as follows:
in cell A2 ... 8:00 AM
in cell B2 ... 5:00 PM
then to get the total hours worked you enter the following formula in cell C2
=B2-A2 and then CUSTOM format it as [h]:mm:ss to get the result in Hours, Minutes, and Seconds as 9:00:00
HTH
_________________
Yogi Anand
Edit: Deleted reference to inactive web site from signature line This message was edited by Yogi Anand on 2003-01-19 18:32
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.