time formula

R

rlvrbyusa

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.
 
P

Peo Sjoblom

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

http://nwexcelsolutions.com
 
Top