| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I need to measure hours between two events(time/date) to give me .
|
|
#2
|
|||
|
|||
|
On Wed, 11 May 2005 15:45:01 -0700, iartis
wrote: =DateTime2 - DateTime1 Format result as [h], or [h]:mm --ron |
|
#3
|
|||
|
|||
|
Hi Iartis
Say A1 has the starting Time/Date and A2 has the ending Time/Date then the following formula will give you the number of hours A2 occurs after A1 =(A2-A1)*24 Just remember to format as General the cell in which you enter this formula. Alok Joshi "iartis" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Hybrid Mode
