S
stevendavina
I think i need help also!!!
I have a series of minutes and seconds time in a column e.g
1.12 = 1 min 12 sec
2.54 = 2 min 54 sec
etc
etc
When I come to total them I am aware they are totalling in values of
100, however I need to convert them back to minutes and seconds
e.g. the total of one column is 25.89 = but I need this to be in
minutes and seconds
I have a lot of coloumns so need an easy formula
How do i convert this value to minutes and seconds
Thanks
I have a series of minutes and seconds time in a column e.g
1.12 = 1 min 12 sec
2.54 = 2 min 54 sec
etc
etc
When I come to total them I am aware they are totalling in values of
100, however I need to convert them back to minutes and seconds
e.g. the total of one column is 25.89 = but I need this to be in
minutes and seconds
I have a lot of coloumns so need an easy formula
How do i convert this value to minutes and seconds
Thanks