Calculation Using Time

R

Rodney

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

T. Valko

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
 
Top