G
Guest
I want to set up a spreadsheet to work out pay from hours worked
A B C D E
1 time time hours rate total
2 start fin worked per hr
3 9:00 17:30 8:30 £17 £144.50
How do I convert the hours worked (8½) into a figure that can be used in
formula E3=Sum(C3/D3)
A B C D E
1 time time hours rate total
2 start fin worked per hr
3 9:00 17:30 8:30 £17 £144.50
How do I convert the hours worked (8½) into a figure that can be used in
formula E3=Sum(C3/D3)