Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 05, 08:01 PM
Jboerding
 
Posts: n/a
Default 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   Report Post  
Old July 6th 05, 08:15 PM
Barb R.
 
Posts: n/a
Default

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


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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=385008



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time difference to the half hour Ken Ivins Excel Worksheet Functions 6 July 17th 05 05:48 PM
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM
Round Time with Conditions KimLL Charts and Charting in Excel 1 February 15th 05 04:23 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
convert 100 minute hour to a 60 minute hour Todd Excel Worksheet Functions 1 November 15th 04 06:14 PM


All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017