Any "day" but I have been in the egg-nog.
Tanoaks for the correction
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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?