ExcelBanter - DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL (https://www.excelbanter.com/excel-discussion-misc-queries/54473-difference-between-two-time-stamps-decimal.html)

Giulia

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

Niek Otten

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

Giulia

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

David Biddulph

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

All times are GMT +1. The time now is 06:14 PM.