Time Trouble
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
|