Post by scrappinghappy on Jun 30, 2016 22:20:46 GMT
I'd greatly appreciate it if any google sheet experts can help me.
The company I work for uses a google sheet to track billable hours for me. Almost all my time is less than 20 hours a week except when I work extra a couple times every other month and it pushes it over 24 hours.
Here's the formula I use to calculate my paycheck but it doesn't work when it's over 24 hours. Then it only counts the minutes and hours over 24.
Entries may look like this.
4:50
3:30
6:10
5:50
4:10
Totals: 24:30:00
Paycheck: Should be $4900 except here I am getting a returned value of $100 (calculated using =(HOUR(C11)+(MINUTE(C11)/60))*200)
I get the same error when I try in excel, fwiw. What am I doing wrong and how do I fix it?
The company I work for uses a google sheet to track billable hours for me. Almost all my time is less than 20 hours a week except when I work extra a couple times every other month and it pushes it over 24 hours.
Here's the formula I use to calculate my paycheck but it doesn't work when it's over 24 hours. Then it only counts the minutes and hours over 24.
Entries may look like this.
4:50
3:30
6:10
5:50
4:10
Totals: 24:30:00
Paycheck: Should be $4900 except here I am getting a returned value of $100 (calculated using =(HOUR(C11)+(MINUTE(C11)/60))*200)
I get the same error when I try in excel, fwiw. What am I doing wrong and how do I fix it?
I find date formulas can be a PITA.