| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Date Format to Minutes
I have a spreadsheet from an outside source and the Minutes are formatted as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM but in the actual cell, it looks like this: 94:00:00. How can I get the cell to read just 94? Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert hours format to decimal or minutes (exp. 1:15:00 = 75 min. | Excel Worksheet Functions | |||
| HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES | Excel Worksheet Functions | |||
| Trying to convert hh.mm.ss in General format to minutes | Excel Worksheet Functions | |||
| How do I convert hours, minutes, and seconds into decimal format? | Excel Worksheet Functions | |||
| Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
Threaded Mode
