Help

Labor/Duration Calulation Formula

Topic Labels: Formulas
Solved
Jump to Solution
703 1
cancel
Showing results for 
Search instead for 
Did you mean: 
cweisenburgh
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
cweisenburgh
4 - Data Explorer
4 - Data Explorer

Through some trial and error, I ended up figuring it out! Posting in case it helps someone in the future

(Duration/3600)*90

See Solution in Thread

1 Reply 1
cweisenburgh
4 - Data Explorer
4 - Data Explorer

Through some trial and error, I ended up figuring it out! Posting in case it helps someone in the future

(Duration/3600)*90