Creating a timesheet in Excel

[bgoodell]

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

 

[robfo0]

bgoodell,

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

 

[brettvba]

try
=(a2-a1)
where the start time is in a1 and finish is a2
you would want to use army time as well
eg 17:00

 

[bgoodell]

Thanks everybody!!!! - you guys are so fast and helpful - I will spread the word (if that is okay)

 

[Yogi Anand]

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