adding values and converting the sum to hours and minutes
Hi
Enter numbers as 2:18 & 2:54 in A1:A2, or use Find / Replace to substitute
"," with ":" then
=sum(A1:A2)
Regards,
Per
"rob3108" skrev i meddelelsen
...
Where I am adding values-say 2.18 and 2.54, how to I get the sum to
display
the total as if the values wre hour and minutes i.e. 5.12 hours rather
than
4.72?
Thanks
|