close
If I have selected a range of cell and have entered a formula to get the sum
of these cells. How do I get that cell to show the sum in hour and minutes.
Insted of just the sum of the selected range.
Format as [hh]:mm? That assumes the date in the range are time values, if it
is hours like 7 instead of 7:00 use the same format but add this to the sum
=SUM(Range)/24
--
Regards,
Peo Sjoblom
nwexcelsolutions.comquot;rlvrbyusaquot; gt; wrote in message
...
gt; If I have selected a range of cell and have entered a formula to get the
gt; sum
gt; of these cells. How do I get that cell to show the sum in hour and
gt; minutes.
gt; Insted of just the sum of the selected range.
全站熱搜
留言列表
