Thread: How can I calculate hours in a Hourly schedule in Excel?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SUPERNAM
 
Posts: n/a
Default How can I calculate hours in a Hourly schedule in Excel?
Thanks

"Bob Phillips" wrote:

=(B2-A2)+(D2-C2)

will give 16:30. If you want it as decimal, just multiply by 24.

--

HTH

RP

"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks



Reply With QuoteReply With Quote