adding values and converting the sum to hours and minutes
 

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

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

adding values and converting the sum to hours and minutes
 

A very nice solution!

In one step:

=SUBSTITUTE(A1,".",":")+SUBSTITUTE(A2,".",":") and format as time
--
Gary''s Student - gsnu200794


"Per Jessen" wrote:

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