MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time subtraction


Posted by Ken Aldag on December 29, 2000 7:17 AM

I am trying to subtract 30 minutes from a total of hours. Say:

a1=07:00
b2=15:30

I want to remove the 30 minutes for a acurate time total. I am using =(b2-a1)-30 which dose'nt work.

Ken


Posted by cpod on December 29, 2000 7:53 AM

Try this:

=(B2-A1)-30/(60*24)

Then format the cell for time.