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

=(A1-B1)*24. Format as General, not as time

--
Kind regards,

Niek Otten

"Giulia" <Giulia@discussions.microsoft.com> wrote in message
news:CA0F9DAC-04D8-4968-90CA-B8F2AFF03FC9@microsoft.com...
> 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

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" <Giulia@discussions.microsoft.com> wrote in message
> news:CA0F9DAC-04D8-4968-90CA-B8F2AFF03FC9@microsoft.com...
> > 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" <Giulia@discussions.microsoft.com> wrote in message
news:CA0F9DAC-04D8-4968-90CA-B8F2AFF03FC9@microsoft.com...
> 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

For time diff larger than 24 hours you can use:

=(A1-INT(A1)+MOD(INT(A1),24))*24