| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL
Help I am been driven mad!
Does anyone know how to find the difference between two time stamps giving the result as a time decimal. I.E. 16:45 - 12:00 = 4.75 hrs |
|
#2
|
|||
|
|||
|
DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL
=(A1-B1)*24. Format as General, not as time
-- Kind regards, Niek Otten "Giulia" wrote in message ... Help I am been driven mad! Does anyone know how to find the difference between two time stamps giving the result as a time decimal. I.E. 16:45 - 12:00 = 4.75 hrs |
|
#3
|
|||
|
|||
|
DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL
Thankyou so much I can't beleive its really that simple - pretty humbling !
"Niek Otten" wrote: =(A1-B1)*24. Format as General, not as time -- Kind regards, Niek Otten "Giulia" wrote in message ... Help I am been driven mad! Does anyone know how to find the difference between two time stamps giving the result as a time decimal. I.E. 16:45 - 12:00 = 4.75 hrs |
|
#4
|
|||
|
|||
|
DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL
"Giulia" wrote in message
... Help I am been driven mad! Does anyone know how to find the difference between two time stamps giving the result as a time decimal. I.E. 16:45 - 12:00 = 4.75 hrs =(A1-A2)*24 and format as number rather than time -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time for some help (Please!) | Excel Worksheet Functions | |||
| Decimal Time | Excel Worksheet Functions | |||
| If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
| need help: time difference between two ceels in a column | New Users to Excel | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Linear Mode
