Tech Support banner

Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter #1 (Edited)
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!
 

·
Registered
Joined
·
310 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?
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top