close
I need to know how to add hours and minutes, and get the sum to be displayed in hours and minutes, rather than days.
Example:
A1 05:30
A2 05:30
A3 05:30
A4 05:30
A5 05:30
A7 =SUM(A1:A5)
A7 displays quot;03:30quot;, but I wish it to display the total hours and minutes which should be quot;27:30quot;.
Is this possible?
hi!format A7
custom gt; [hh]:mm
-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539015Perfect, thank you.
全站熱搜
留言列表
