adding values and converting the sum to hours and minutes

R

rob3108

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
 
P

Per Jessen

Hi

Enter numbers as 2:18 & 2:54 in A1:A2, or use Find / Replace to substitute
"," with ":" then

=sum(A1:A2)

Regards,
Per
 
G

Gary''s Student

A very nice solution!

In one step:

=SUBSTITUTE(A1,".",":")+SUBSTITUTE(A2,".",":") and format as time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timesheet hours format not adding 2
Adding up hours and minutes 18
I have 3053 minutes and I want to convert to hours and minutes 2
ADDING HOURS AND MINUTES 2
Adding Hours 1
Adding hours and minutes 7
Convert total minutes to hours and minutes 3
Calculating time, hours and minutes 1

Top