| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change time h:mm to a decimal number based on hours
We have a spreadsheet with columns for time started and time finished. The
data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
Hi,
Just multiply it by 24 and format as a regular number Cheers "Snort5525" wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
Try this:
=(B1-A1)*24 and format the cell as Number with 2dp. Copy down as necessary. Hope this helps. Pete On May 31, 4:56 pm, Snort5525 wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
=ROUND((Finish-Start)*24,2) "Snort5525" wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
Thanks to all for their help! I did not anticipate such a quick response, and
you saved me a lot of time. "Pete_UK" wrote: Try this: =(B1-A1)*24 and format the cell as Number with 2dp. Copy down as necessary. Hope this helps. Pete On May 31, 4:56 pm, Snort5525 wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
Thank you for your assistance.
Your quick answer was right on point. "DazzaData" wrote: Hi, Just multiply it by 24 and format as a regular number Cheers "Snort5525" wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change time h:mm to a decimal number based on hours
Your help is greatly appreciated.
"Toppers" wrote: =ROUND((Finish-Start)*24,2) "Snort5525" wrote: We have a spreadsheet with columns for time started and time finished. The data shows up as hh:mm. A third column is the difference between these first two, showing total hours and minutes spent on the task. How can I show the data in the third column as hours to two decimal places? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert dd:hr:mn:ss to Decimal number of hours | Excel Discussion (Misc queries) | |||
| How can I change time format to decimal without losing hours? | Excel Discussion (Misc queries) | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| converting a decimal number to hours and seconds | Excel Worksheet Functions | |||
| how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
Linear Mode
