Time sheets

[scorpio_e]

DateSun JohnSmith
Office In Out
9 5
Lunch Out In
2 3

Sheet one

Employee Name
John Smith Hours 7

Sheet Two

Above is an example of what I am trying to do. Sheet one the start - end time and lunch is recorded. Sheet two does all of the calcualtions and returns the Total hours worked for the day. I can do this easily if I use Military time. I wanted to use standard time (ie 5:30 PM). What I end up with is a mess when I start using IF statements. I have employees starting before 12pm and after 12pm. That causes a major problem for me. Any suggestons on the best way to ge this started???

[Yogi Anand]

On 2002-05-19 14:58, scorpio_e wrote:
DateSun JohnSmith
Office In Out
9 5
Lunch Out In
2 3

Sheet one

Employee Name
John Smith Hours 7

Sheet Two

Above is an example of what I am trying to do. Sheet one the start - end time and lunch is recorded. Sheet two does all of the calcualtions and returns the Total hours worked for the day. I can do this easily if I use Military time. I wanted to use standard time (ie 5:30 PM). What I end up with is a mess when I start using IF statements. I have employees starting before 12pm and after 12pm. That causes a major problem for me. Any suggestons on the best way to ge this started???

If your start time and end time for a 24 hour environment are in cells A2 and B2, then use the following formula:

=IF(B2

[ This Message was edited by: Yogi Anand on 2002-05-19 15:37 ]