Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
|
|||
|
|||
Answer: Time calculation of 8:00 am - 4:30 pm at 8.5 hours How???
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Schedule hours calculation | Excel Discussion (Misc queries) | |||
HOURS CALCULATION | Excel Discussion (Misc queries) | |||
Time (Hours) calculation | Excel Worksheet Functions | |||
How do add time/hours to get answer in hours if Ans24 | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |