Hi
The following formula should work
IF(ISBLANK(B5),"Not Sent",IF(A5>B5,A5-B5,B5-A5))
Format col C under custom format h:mm
Cheers
Hi
The following formula should work
IF(ISBLANK(B5),"Not Sent",IF(A5>B5,A5-B5,B5-A5))
Format col C under custom format h:mm
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks