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
Forum Discussion
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
