I'm trying to calculate cost/price in my shop by hourly rate. I have the Time Tracker linked with my Duration Field, but something is off in the calculation. IE one duration is 0:43 (0 full hours;43 minutes) but the calculation cost is showing $3,870. It should be $64.4999 with the formula (Duration/60)*90. How do I get it to calculate the correct amount wether the billable hours are 1h:43m or 0h:43m? Thank you in advance
Solved
Labor/Duration Calulation Formula
+2Best answer by cweisenburgh
Through some trial and error, I ended up figuring it out! Posting in case it helps someone in the future
(Duration/3600)*90
+2Through some trial and error, I ended up figuring it out! Posting in case it helps someone in the future
(Duration/3600)*90
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.