Frustrated: Found formula for calculating time here in the community
So i found this formula and it is giving me #unparseable. Not sure what I'm doing wrong:
=INT(SUM@row)+":"+IF((SUM@row - INT(SUM@row))*60<10,"0")+(SUM@row - INT(SUM@row))*60
I have 3 columns:
Start End Total Hours
I'm using military time and I need to calculate total hours.
Please let me know what I'm doing incorrectly.
Help Article Resources
Check out the Formula Handbook template!