LinkBack URL
About LinkBacks
I was having issues calculating the minutes between two dates and having the results returned as a whole number. Found this formula worked best:
=IF(I1<>0,(DAY(I1-H1)*60*24+HOUR(I1-H1)*60+(MINUTE(I1-H1))),0)
I was having issues calculating the minutes between two dates and having the results returned as a whole number. Found this formula worked best:
=IF(I1<>0,(DAY(I1-H1)*60*24+HOUR(I1-H1)*60+(MINUTE(I1-H1))),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks