Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sum hours in Excel and convert to decimal numbers?
I am keep track of time that I am working on a project and have figured out
how to have the results calculate the product. But how do I some a column of hours? Or how do I change the products into decimal numbers? e.g. 1:00 should equal 1.0 |
#2
|
|||
|
|||
Multiply your result by 24
Change your formula to =(Your_Formula)*24 Be sure to format the result as General and not Time. Format | Cells | Number |General. tj "Heinsohn" wrote: I am keep track of time that I am working on a project and have figured out how to have the results calculate the product. But how do I some a column of hours? Or how do I change the products into decimal numbers? e.g. 1:00 should equal 1.0 |
#3
|
|||
|
|||
http://www.cpearson.com/excel/datetime.htm#WorkHours
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Heinsohn" wrote in message ... I am keep track of time that I am working on a project and have figured out how to have the results calculate the product. But how do I some a column of hours? Or how do I change the products into decimal numbers? e.g. 1:00 should equal 1.0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Word table with paragraphing to Excel? | Excel Discussion (Misc queries) | |||
How do I convert decimal inches to fractions in excel | Excel Discussion (Misc queries) | |||
Improve Convert function in Excel | Excel Worksheet Functions | |||
how do i convert an excel file from a mac to a file on excel for . | Excel Discussion (Misc queries) | |||
How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) |