convert time from 60 minute hour to 100 minute hour

G

Guest

Hello,

I have this formula set up in excel.

=FLOOR(F5,1/24)+VLOOKUP(MINUTE(F5),FORMULA!A1:B5,2)

It returns 5:45, I would like it to return 5:75.

What do I need to change in my formula to make it read in the 100 min. hour
instead of 60 min. hour. I have a seperate column doing this, but would like
to accomplish it within one column.

Thanks.
 
G

Guest

Do you really want 5:75? Do you want to be able to do calculations based on
the result or just display it?
 

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

Top