Thread: Time Trouble
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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