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:


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


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

Try this:


Then format the cell for time.