Remember Me?

#1
July 6th 05, 08:01 PM
 Jboerding Posts: n/a
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
July 6th 05, 08:15 PM
 Barb R. Posts: n/a

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
July 6th 05, 11:30 PM
 Morrigan Posts: n/a

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

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ken Ivins Excel Worksheet Functions 6 July 17th 05 05:48 PM ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM KimLL Charts and Charting in Excel 1 February 15th 05 04:23 PM agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM

All times are GMT +1. The time now is 12:00 PM.