Hi everyone, I'm now required to start using Excel full time as I'm graduating in 3 months. So I imagine I'll be back :D
My issue is an Excel and maths problem. I need to create this table:-
task completed (replacing files, template edits) Time taken (0:15secs - 2 mins) and Cost (all tasks cost 1.25 per minute)
Task--------------------Time -------Cost
Replacement edit ---- 0:45secs ---- ??
My best guess would be work out the cost per second- 0.028p, multiply it by time taken and then Alt+e+s+f to copy the formula down. Any cleaner way?
Thanks!
image001.png
Bookmarks