kevinb11
Active Member
- Joined
- Feb 7, 2012
- Messages
- 353
Need a Formula to figure the difference between time then round to nearest 15 minutes and change to number with a decimal point. Can it be done in one step or does it need to be multiple steps?
Tried =MOD(MROUND((B29-B28),"0:15"),1)
But I keep getting NUM! error
Thanks for any help you can provide
Tried =MOD(MROUND((B29-B28),"0:15"),1)
But I keep getting NUM! error
Thanks for any help you can provide