I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?


Thanks

Just need to subtract:

=A2-A1

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Jack Black" wrote in message
...
I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?


Thanks

=(B2-A2)*24

--
__________________________________
HTH

Bob

"Jack Black" wrote in message
...
I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?


Thanks

On Mon, 4 Aug 2008 08:05:15 +0100, "Bob Phillips"
wrote:

=(B2-A2)*24
Thank you, I get hours, minutes and seconds. What I would like is
hours only to 2 digits where 9:15 would show as 9.25.

Thanks

=(B2-A2)*24 and format the result as number or general.
--
David Biddulph

"Jack Black" wrote in message
...
On Mon, 4 Aug 2008 08:05:15 +0100, "Bob Phillips"
wrote:

=(B2-A2)*24
Thank you, I get hours, minutes and seconds. What I would like is
hours only to 2 digits where 9:15 would show as 9.25.

Thanks

By my reckoning, if the result of B2-A2 is 9:15, it looks to me that my
formula does return 9.25. And isn't 9:15 hours and minutes anyway?


--
__________________________________
HTH

Bob

"Jack Black" wrote in message
...
On Mon, 4 Aug 2008 08:05:15 +0100, "Bob Phillips"
wrote:

=(B2-A2)*24
Thank you, I get hours, minutes and seconds. What I would like is
hours only to 2 digits where 9:15 would show as 9.25.

Thanks