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

Hi Rodney:

With a formula or vba code?

cheers,
gt

"Rodney" wrote:

> 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

--
Biff
Microsoft Excel MVP


"Rodney" <(E-Mail Removed)> wrote in message
news:EBA0B1A7-6A3D-4546-9D96-(E-Mail Removed)...
> How do I calculate the difference between two times, and subtract 30
> minutes
> if the time exceeds 8 hours?