# convert time from 60 minute hour to 100 minute hour

1. ## convert time from 60 minute hour to 100 minute hour

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.

2. ## RE: convert time from 60 minute hour to 100 minute hour

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

"Jboerding" wrote:

> 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.
>
>

3. Hmm.....put "*100/60" at the end of the vlookup?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1