Formulas

N

Nancy

I am trying to convert minutes into hundreds...I need to show the following
1.15 as 1.25
1.30 as 1.50
1.45 as 1.75
Is there a formula for this conversion?
Thanks,
 
B

Bernard Liengme

If the numbers really are 1.15 with decimal and not 1:15 with colon, use
=INT(A1)+MOD(A1,1)*100/60

If the values are real time (1:15) use =A1*24 and format as General or
Number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert 1.15 to 1.25 for time purposes. 3
IF THEN formulas 1
vlookup for max value or any value>0 1
UNION Querie 6
Excel Lookup Formula 4
Difference in Time hour what formula to use in excel? 4
enter a set value in adjacent cell 2
Timesheet calculations 1

Top