Forum Discussion

Copper Contributor

Jul 22, 2018

How to change hournotation into amount?

How to change the hournotation example 3:30 into 3,50? How to make the total of hournotation? example : 3:30 + 3:25 + 4:75

Silver Contributor

Jul 22, 2018

Hi Sandra,

To change this:

3:30

To this:

3.50

Please use this formula:

=A1*24

To add different time values together, you can use either this formula in case if you want the total to be in the time format:

=TEXT(SUM(A1:A15),"[h]:mm:ss;@")

Or you can use this one if you want the total in decimal format:

=SUM(A1:A15)*24

Regards