| Home |
| Search |
| Today's Posts |
|
#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
|
|||
|
|||
|
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? -- 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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| Round Time with Conditions | Charts and Charting in Excel | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions | |||
Linear Mode
