Creating a timesheet in Excel

bgoodell · Apr 18th, 2002, 09:36 PM

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 · Apr 18th, 2002, 09:44 PM

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 · Apr 18th, 2002, 09:44 PM

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 · Apr 18th, 2002, 09:49 PM

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

Yogi Anand · Apr 18th, 2002, 09:52 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 09:36 PM	#1
bgoodell New Member Join Date: Apr 2002 Location: Roseville, California Posts: 5	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

Apr 18th, 2002, 09:44 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	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

Apr 18th, 2002, 09:44 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	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

Apr 18th, 2002, 09:49 PM	#4
bgoodell New Member Join Date: Apr 2002 Location: Roseville, California Posts: 5	Thanks everybody!!!! - you guys are so fast and helpful - I will spread the word (if that is okay)

Apr 18th, 2002, 09:52 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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 ]