Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating pay from Time in Excel
Roger, Yes, I had forgotten "time" was a number. That will make it work. Thank you!!! Mike- lftrypft
- Post #7
- Forum: Microsoft: Office
-
Calculating pay from Time in Excel
Thank you Roger, I formatted the time cell with a custom format [h]:mm:ss. I did this so when I added the daily hours together, I would get a number over 24 hours. A B C 1 Hours:Minutes worked 2 9:30 Mon 3 8:00...- lftrypft
- Post #3
- Forum: Microsoft: Office
-
Calculating pay from Time in Excel
I'm creating a table to calculate overtime pay per week. I've summed the total hours per week, but I don't know how to take the hours and times the hours and remaining minutes by $20/hour. Such as 41:00:00*$20/hour. Any ideas? Thanks, Mike- lftrypft
- Thread
- Replies: 6
- Forum: Microsoft: Office
