Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
 

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?

Answer: Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
 

1. Enter the start time (8:00 am) in cell A1 and the end time (4:30 pm) in cell B1.
2. In cell C1, subtract the start time from the end time using the formula "
   Code:

   ---

   =B1-A1

   ---

   ".
3. The result in cell C1 will be displayed in the default time format, which is hours:minutes. However, we need to convert it to decimal hours to get the total number of hours worked.
4. To convert the time to decimal hours, multiply the result in cell C1 by 24. For example, if the result in cell C1 is 8:30, then multiply it by 24 to get 8.5.
5. The final result will be displayed in cell C1 as 8.5 hours.

Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
 

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?

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?

Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
 

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?