Trying to convert a Time Format 1:24:23 to total amount of

[Paul D]

Trying to convert a Time Format 1:24:23 to total amount of
minutes

Also I have 24 secounds, I need to round up to 30 secounds
32 secounds, I need to round up to 60 secounds

 

[Frank Kabel]

Hi
for the first one use the formula
=A1*24*60

for the rounding issue try
=MROUND(A1*24*60*60,30)/(24*60*60)

 

[Guest]

Excel will not allow me to use the funtion MROUND, any
ideas

 

[Frank Kabel]

Hi
sorry I forgot: You have to install/enable the Analysis Toolpak Addin
for this: Goto 'Tools - Add-ins' and check this Add-in