Calculation Using Time

  • Thread starter Thread starter Rodney
  • Start date Start date
R

Rodney

How do I calculate the difference between two times, and subtract 30 minutes
if the time exceeds 8 hours?
 
Try this:

=MOD(B1-A1,1)*24-((MOD(B1-A1,1)*24>8)*30/1440*24)

Format as GENERAL or NUMBER

That'll return the the difference in decimal format: 8, 8.5, 10.75
 
You must log in or register to reply here.

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

Time Calculated minus breaks & lunch 2
Length of time from date/time custom format 2
Calculate times between dates and times in Excel 1
Calculating time values 2
Date/ Time Formula in Excel 2
Determine if night shift by start & end time 2
how to calculate hours worked daily & minus 30 min lunch, 7am-5pm 1
subtract the time difference from another time difference 3

Back
Top