Hi, i've got a spreadsheet that i need to create, and i'm having a few problems getting the formulas correct.
I've got 18 columns for hours worked each week, i then need to calculate the average hours worked each week over the 18 weeks and present it as an hours and minutes format (of which i'm using the average formula), but my main problem is i need to present the result as hours and minutes worked, and so far i've only got it coming up in a 24 hour time format
can anyone help?
thanks
Leon.
I've got 18 columns for hours worked each week, i then need to calculate the average hours worked each week over the 18 weeks and present it as an hours and minutes format (of which i'm using the average formula), but my main problem is i need to present the result as hours and minutes worked, and so far i've only got it coming up in a 24 hour time format
can anyone help?
thanks
Leon.