Here's the link to OP's other post, for reference:

http://www.microsoft.com/office/comm...f-fb01c927bd9e
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JP Ronse" wrote:

See your post "Calculate a value between 2 times" and the reply of Chip
Pearson.

Wkr,

JP
Calculate a value between 2 times

"Maresa" wrote in message
...
sorry if this is a duplicate, but I cannot see the question I posted last
night.
I need to calculate night shift allowance between the hours 18:00 and 6:00
the shift might run from 15:00 to 23:00, the allowance is then = 5 hours,
or
it might start at 05:00 to 14:00, the answer should then be 1 hour.