Excel Formula Help Please!!!!!

emt596 · 06-14-2007, 01:50 PM

HI, I am trying to make an excel sheet that will calculate my work hours. I work 24 hour shifts or better and I want to be able to just type in a clock in and a clock out time and let it give me a number of hours and minutes as a result... how do I do this???

Any help would be greatly apreciated....

**Glaswegian** · 06-14-2007, 02:00 PM

Hi

How about just a simple B1-A1 formula? If your cells are formatted as time and you input the values then that should do the trick.

**tosh9i** · 06-14-2007, 03:37 PM

This might not be exactly what you're looking for, but it's a start:

Weekly time sheet

http://office.microsoft.com/en-us/te...CT101172771033

You can find more here:

http://office.microsoft.com/en-us/te...heet&av=TPL000

Even if you don't get paid for overtime, you can just enter the same "normal" hourly rate to give you an accurate number. Plus, you can add another column to add up the regular hrs and overtime hrs.

emt596 · 06-14-2007, 07:24 PM

Thank you for the help. I really appreciate it.

06-14-2007, 01:50 PM	#1 (permalink)
emt596 Registered User Join Date: Jan 2007 Posts: 3 OS: xp	Excel Formula Help Please!!!!! HI, I am trying to make an excel sheet that will calculate my work hours. I work 24 hour shifts or better and I want to be able to just type in a clock in and a clock out time and let it give me a number of hours and minutes as a result... how do I do this??? Any help would be greatly apreciated....

06-14-2007, 02:00 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,408 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel Formula Help Please!!!!! Hi How about just a simple B1-A1 formula? If your cells are formatted as time and you input the values then that should do the trick. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

06-14-2007, 03:37 PM	#3 (permalink)
tosh9i TSF Enthusiast Join Date: Aug 2006 Posts: 3,811 OS: Windows XP	Re: Excel Formula Help Please!!!!! This might not be exactly what you're looking for, but it's a start: Weekly time sheet http://office.microsoft.com/en-us/te...CT101172771033 You can find more here: http://office.microsoft.com/en-us/te...heet&av=TPL000 Even if you don't get paid for overtime, you can just enter the same "normal" hourly rate to give you an accurate number. Plus, you can add another column to add up the regular hrs and overtime hrs.

06-14-2007, 07:24 PM	#4 (permalink)
emt596 Registered User Join Date: Jan 2007 Posts: 3 OS: xp	Re: Excel Formula Help Please!!!!! Thank you for the help. I really appreciate it.