Sir Babydum GBE
03-08-2012, 11:17 AM
Hi
I'm working on a formula that has many parts, and I need to save my IFs for nestings.
Is there a formula that will calculate the following please?
Our staff sign in the time (to the second) in A1. When they go home they sign out (B1).
In C1 how do I (without using IFs) subtract A1 from B1 to return the time worked, rounded (up/down) by 15 minute intervals? BUT, the maximum result returned should be 8 (hours)?
Thx in advance
Damian
I'm working on a formula that has many parts, and I need to save my IFs for nestings.
Is there a formula that will calculate the following please?
Our staff sign in the time (to the second) in A1. When they go home they sign out (B1).
In C1 how do I (without using IFs) subtract A1 from B1 to return the time worked, rounded (up/down) by 15 minute intervals? BUT, the maximum result returned should be 8 (hours)?
Thx in advance
Damian