Hi,

I tryed this and it worked, hope it works for you to


14:30 (Cell A1) 12:18(Cell B1)
A1*24 (Cell A2) B1*24(Cell B2)
TRUNC(A2) (Cell A3) TRUNC(B2) (Cell B3)
A2-A3 (Cell A4) B2-B3 (Cell B4)
(A4*60)/100 (Cell A5) (B4*60)/100 (Cell B5)
A3+A5 (Cell A6) B3+B5 (Cell B6)

TOTAL A6+B6

The cells working the formulas can be hidden by marking the row height to 0

Hope I was helpfull

"CraigR53" wrote:

I'm creating a custom timecard to compute time spent by a given employee on
various projects. When I try to add daily totals together to get weekly
totals and that total exceeds 23:59, I can't find a format that will display
it as such -- it always reduces it to a time under 23:59. (Example: 14:30 +
12:18 = 26:48, but it displays as 2:48) How can I fix this?