LinkBack URL
About LinkBacks
The first formula
=IF(B7="na",0,((C7-B7)*24))
I need to add
=IF(C7-B7)*24>6,-0.5
to get something like this
=IF(B7="na",0, ((C7-B7)*24))>6 -.5 otherwise (C7-B7)*24))
The first formula
=IF(B7="na",0,((C7-B7)*24))
I need to add
=IF(C7-B7)*24>6,-0.5
to get something like this
=IF(B7="na",0, ((C7-B7)*24))>6 -.5 otherwise (C7-B7)*24))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks