Convert [h]:mm sum total format to number format

G

Guest

I total time cards in [h]:mm format and would like to convert the total to a
number format displayed as hh.00 where the number of hours is the same but
the minutes would display in decimal format. Example; total = 25:30 (25
hours, 30 minutes) and I want to convert that to read as 25.5 hours.
 
M

Max

Assume you are totalling in A3: =SUM(A1:A2)
Just amend the formula in A3 to : =SUM(A1:A2)*24
then format A3 as General (or as Number)
 

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

Subtracting time...again 2
How calculate difference between [t]:mm-format and general format 3
Excel Convert Datetime Stamp to HH and MM Worked 7
Summing up different time formats 6
convert hours and minutes into days 2
Time is locked to General format 5
ADDING TIMES 3
values > 24/48 hours 2

Top