Thread: Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
Wouldn't you prefer *24, rather than *25, Bernard?
--
David Biddulph

"Bernard Liengme" wrote in message
...
With A1 displaying 8:00 AM, and B1 displaying 4:30 PM, the formula =B1-A1
results in 8:30 when the cell has format h:mm. The formula =(b1-A1)*25
displayed 8.5 when General format

If you need to cross midnight, use =(B1-A1)+(A1B1) the last term add 1 to
the results of the subtraction
best wishes & Merry Christmas
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"KC1952" wrote in message
...
I am trying to calculate the time between 8:00 am and 4:30 pm. It is
giving
me 8 hours only and not the 8.5 hrs. Is there a way I can do this?




Reply With QuoteReply With Quote