| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert time format to a decimal
I have a forumula that calculates total time. The results are shown in a
time format (66:30:00). How can we convert this to a decimal (66.5 hours)? Thank you for your help. Michele |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert time format to a decimal
multiply by 24 and format it as general.
=a1*24 (and format that cell as general) Michele wrote: I have a forumula that calculates total time. The results are shown in a time format (66:30:00). How can we convert this to a decimal (66.5 hours)? Thank you for your help. Michele -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert time format to a decimal
Hi!
Multiply by 24: =Your_Formula(.............)*24 Biff "Michele" wrote in message ... I have a forumula that calculates total time. The results are shown in a time format (66:30:00). How can we convert this to a decimal (66.5 hours)? Thank you for your help. Michele |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert utc to a readable time format? | Excel Discussion (Misc queries) | |||
| How do I convert a time to text format. | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| add time and convert it to currency | Excel Worksheet Functions | |||
Linear Mode
