Hopefully this will be a simple question to all you masters of the mystic Excel (as you may gather I'm totally lost with this program)...
Ive managed to create a basic invoicing system that adds Flight time and I'd like it to multiply this by an hourly rate, but I'm struggling.
Is there a simple way of formatting the cells to convert the minutes to a decimal or is it more complicated than this? If possible I'd like to keep time in one cell containing hh:mm, rather than having two cells for hours and minutes respectively (although if seperate cells make the solution easier then so be it).
I hope this makes sense?
If anyone can help me, I would be very grateful
Thanks
Flying Mushroom