Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here lies the problem. I'm cheap, I want to be paid for every minute that I
work, I do the time cards for work and I'm using Excel to perform the functions. I have no problem with adding and subtracting the times in single cells or totalling all of the time. If I come up with a person having 47 hours and 13 minutes how do I get Excel to convert 47:13 to 47.22 so that I can then multiply the 40 by hourly rate and the 7.22 by 1.5 the hourly rate ? -- Thank You, God Speed, and Semper Fidelis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |