| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting a number to time formatted as minutes
Hello,
Would like to ask for your help. How would I go about taking a number (formatted as general) and convert this to minutes. I have tried taking the number divided by 60, but I cannot seem to find the right format. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting a number to time formatted as minutes
One more on this topic. How do I take a number like (97.5) and convert this
to time (97:30) "JR" wrote: Hello, Would like to ask for your help. How would I go about taking a number (formatted as general) and convert this to minutes. I have tried taking the number divided by 60, but I cannot seem to find the right format. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting a number to time formatted as minutes
One more point - how would this solution look with a vlookup
Thanks "JR" wrote: One more on this topic. How do I take a number like (97.5) and convert this to time (97:30) "JR" wrote: Hello, Would like to ask for your help. How would I go about taking a number (formatted as general) and convert this to minutes. I have tried taking the number divided by 60, but I cannot seem to find the right format. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
Linear Mode
