A
avoiding the ironing
Guest
HELP!
I have columns of start time, end time, break, and gross hours
Then one with the rate of pay.
eg. So if I enter times and it correctly calculated I work 5 hours it shows as 5:00 hours as it's formatted as [h]:mm
Or if I work 4 and half hours it shows as 4:30
Or 4 and quater it's 4:15
Or 4 and three quaters it's 4:45
But I want to calculate the rate of pay by this.
SO the cell with the rate of pay in formatted as a number with 2 decimal spaces. eg £6.00.
What formatting do I need in the answer cell to give me the correct answer. The non whole hours totall throw me!
I have columns of start time, end time, break, and gross hours
Then one with the rate of pay.
eg. So if I enter times and it correctly calculated I work 5 hours it shows as 5:00 hours as it's formatted as [h]:mm
Or if I work 4 and half hours it shows as 4:30
Or 4 and quater it's 4:15
Or 4 and three quaters it's 4:45
But I want to calculate the rate of pay by this.
SO the cell with the rate of pay in formatted as a number with 2 decimal spaces. eg £6.00.
What formatting do I need in the answer cell to give me the correct answer. The non whole hours totall throw me!