Tech Support Forum banner

excel help??

781 Views 2 Replies 3 Participants Last post by  hopper
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!
Status
Not open for further replies.
1 - 3 of 3 Posts
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?
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.
1 - 3 of 3 Posts
Status
Not open for further replies.
Top