excel help??

22bluejen · 09-06-2005, 12:35 PM

Hello,
I am trying to create an excel spreadsheet that works like a time sheet. Colums for time in, lunch, total hours worked, and comp time. Seems simple enough. I am a novice on excel, and have the spreadsheet created, however, I am wondering if anyone knows what formula i would use to have the sheet do the computing for me. for example, in at 7AM out at 4PM 1 hour lunch.....I don't know how to make to calculation work. The queries don't seem to like the time format. Any suggestions would be greatly appreciated!

ricer333 · 09-06-2005, 01:10 PM

What exactly would you put in the spreadsheet and expect as output?

would you have:

IN COL | OUT COL | 1 HR for LUNCH COL |

Or something different?

hopper · 09-06-2005, 03:48 PM

Dates and times can be tough in Excel. Use this article as your bible. I used to do tech support for Excel and I still refer back to it quite a bit.

09-06-2005, 12:35 PM	#1 (permalink)
22bluejen Registered User Join Date: Sep 2005 Posts: 1 OS: win xp	excel help?? Hello, I am trying to create an excel spreadsheet that works like a time sheet. Colums for time in, lunch, total hours worked, and comp time. Seems simple enough. I am a novice on excel, and have the spreadsheet created, however, I am wondering if anyone knows what formula i would use to have the sheet do the computing for me. for example, in at 7AM out at 4PM 1 hour lunch.....I don't know how to make to calculation work. The queries don't seem to like the time format. Any suggestions would be greatly appreciated! Last edited by 22bluejen; 09-06-2005 at 12:46 PM.

09-06-2005, 01:10 PM	#2 (permalink)
ricer333 Registered User Join Date: Sep 2004 Posts: 302 OS: Vista (on Laptop) WinXP Pro SP3 (on Desktop)	clearifcation What exactly would you put in the spreadsheet and expect as output? would you have: IN COL \| OUT COL \| 1 HR for LUNCH COL \| Or something different? __________________ AMD X2 5000+ Black w/ XFX GeForce 8200 MoBo 4GB OCZ DDR2 RAM 3/4 of a TB of data storage between 2 HDD's (no RAID)

09-06-2005, 03:48 PM	#3 (permalink)
hopper Registered User Join Date: May 2005 Posts: 169 OS: XP / Ubuntu 6.10	Dates and times can be tough in Excel. Use this article as your bible. I used to do tech support for Excel and I still refer back to it quite a bit.