SyntaxFix
Write A Post
Hire A Developer
Questions
Just use the formula
120 = (HOUR(A8)*3600+MINUTE(A8)*60+SECOND(A8))/60