Hello All,
I am having a little trouble with a spreadsheet I am creating, if prossible could you please advise the formulas and cell formatting I should be using to enable this to work.
Here goes:
in cell E3 I have a time started (e.g 12:45 pm), In F3 i have time finished (e.g 2:30 pm)
So, what i'm wanting is the time taken in G3 and also, i have the amount of units that is entered manually in H3. I would like I3 to show the time taken per unit.
hope this makes sense and I would be grateful for any advice.
thanks,
Bookmarks