E
Evan Platt
Hello all..
I'm looking for some help with a timecard. I have 4 cells, In, Out,
In, Out. (start, lunch, back from lunch, end of day). A typical entry
would be 7:30, 11:00, 12:00, 4:30. This should be 8 as the 'sum'. I'm
probably missing the obvious, but what would the formula be for this?
I've seen a number of help documents mentioning multiplying the sum by
24, but this doesn't seem to work
I doubt this is possible, but we have additional columns - regular
hours, and overtime hours. Is it possible for excel to only put a
maximum of 8 in the regular hours column, and anything over 8 in the
OT column? If not, I can simply then once I know the hours are say
9.4, put 8 in the regular hours column and 1.4 in the OT myself...
Thanks.
Evan
I'm looking for some help with a timecard. I have 4 cells, In, Out,
In, Out. (start, lunch, back from lunch, end of day). A typical entry
would be 7:30, 11:00, 12:00, 4:30. This should be 8 as the 'sum'. I'm
probably missing the obvious, but what would the formula be for this?
I've seen a number of help documents mentioning multiplying the sum by
24, but this doesn't seem to work
I doubt this is possible, but we have additional columns - regular
hours, and overtime hours. Is it possible for excel to only put a
maximum of 8 in the regular hours column, and anything over 8 in the
OT column? If not, I can simply then once I know the hours are say
9.4, put 8 in the regular hours column and 1.4 in the OT myself...
Thanks.
Evan