Search code examples
excelexcel-formulaexcel-2010

excel formula convert minutes to hundredths

I'm new to excel and my leader has asked me to prepare an excel formula that do the following time equation :

04:15 should converted as 04:25

18:30 should converted as 18:50

33:45 should converted as 33:75

30:14 should converted as 30:23

This formula should convert minutes to hundredths and should not do any thing with the hours such as above example.

I have searched for hours and could find the exact excel formula such this one.

Please guys help my.

Thanks in advance .

Solution

  • I've got this:

    =TEXT(A1,"[hh]") & ":" & FLOOR(MINUTE(A1)*100/60,1)

    Note the use of the TEXT function. This is to format the times such as 30:45, to ensure the output is 30 and not 6.