Here is the scenario. In cell BQ65, I have 7:00 pm. Next to that, in cell BR65, I have 6:00 am. This should total 11.00 hours, yet with the formula I have in cell BS65, the result is showing up as 13.00 hours, so I'm ending up with two extra hours, which is not good.
Here's the formula I have in cell BS65:
=IF(ABS((((BR65-BQ65)*1440)/60))=0,"",ABS(((BR65-BQ65)*1440)/60))
Thank you!
=MOD(BR65-BQ65,1)*24 should do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That did work, thank you very much. So, what does MOD do? I've never used that function before.
i cant really explain it
http://office.microsoft.com/en-gb/ex...010342698.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks