KarmaTheDog
New Member
- Joined
- Feb 17, 2010
- Messages
- 33
Hello all,
I'm not sure if there is an answer to this but here goes:
I have a range of four cells in which time is entered. The time is work hours: in, out, in, out. In an adjacent cell I would like to display only the sum of hours worked past 18:00 hours.
For example, if the four cells read:
10:00, 14:00, 15:00, 19:00
I would like the adjacent cell to recognize that 1:00.
I already have the cells formatted to time. Can anyone help?
Thank you
I'm not sure if there is an answer to this but here goes:
I have a range of four cells in which time is entered. The time is work hours: in, out, in, out. In an adjacent cell I would like to display only the sum of hours worked past 18:00 hours.
For example, if the four cells read:
10:00, 14:00, 15:00, 19:00
I would like the adjacent cell to recognize that 1:00.
I already have the cells formatted to time. Can anyone help?
Thank you