[Rodney]

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

[gt]

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?

[T. Valko]

Try this:

=MOD(B1-A1,1)*24-((MOD(B1-A1,1)*248)*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" wrote in message
...
How do I calculate the difference between two times, and subtract 30
minutes
if the time exceeds 8 hours?