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

K

KC1952

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?
 
B

Bernard Liengme

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)+(A1>B1) the last term add 1 to
the results of the subtraction
best wishes & Merry Christmas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Not Calucating Right 2
Determine if night shift by start & end time 2
Average Time for Specific Item 9
Excel Catagorise AM or PM 7
Calculate Total hours worked during workdays within given shift time. 2
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Calculate the difference betwen two columns -two dates 3

Top