| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I find the amount of hours between times?
I am creating a costed roster spread sheet. I would like to be able to
calculate amount of hours between entered times and result be displayed in decimal number format i.e. In: 8:00am Out: 2:30pm Result: 6.5 Or........ In: 8:00 Out: 14:30 Result: 6.5 Is this possible in excel? If so how? Thanks Jim Gorman |
|
#2
|
|||
|
|||
|
Hi Jim
Sure. With start time in A1 and end time in B1: =(B1-A1+(B1<A1))*24 Format the result cell as decimal number. HTH. best wishes Harald "gormanj" skrev i melding ... I am creating a costed roster spread sheet. I would like to be able to calculate amount of hours between entered times and result be displayed in decimal number format i.e. In: 8:00am Out: 2:30pm Result: 6.5 Or........ In: 8:00 Out: 14:30 Result: 6.5 Is this possible in excel? If so how? Thanks Jim Gorman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| totaling times past 24 hours | Excel Worksheet Functions | |||
| a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
| How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Linear Mode
