W
Wannano
Column A Column B Column C
4/3/07 5:12 PM 4/3/07 7:00 PM 1:48
4/3/07 3:50 PM 4/4/07 7:00 PM 3:10
4/3/07 6:36 PM 4/4/07 4:10 PM 21:34
Column C formated as h:mm
Need help with formula to sum time.
Reg [sum] I get 2:32 then *24 I get 12:48, the correct answer should be 26:32.
Thanks!
4/3/07 5:12 PM 4/3/07 7:00 PM 1:48
4/3/07 3:50 PM 4/4/07 7:00 PM 3:10
4/3/07 6:36 PM 4/4/07 4:10 PM 21:34
Column C formated as h:mm
Need help with formula to sum time.
Reg [sum] I get 2:32 then *24 I get 12:48, the correct answer should be 26:32.
Thanks!