Hi
I am trying to run a spread sheet to log alarm call outs (start and end time). Mostly overnight and so can span midnight.
Once I've captured the elapsed time I need to calculate the charge for the first hour and the charge for the subsequent hour ( or part hour) to give a charge for attending the call out.
I have used all suggested ways to calculate the elapsed time but without consistency.
I have tried to attach a sample sheet but don't seem to be able to add one
Bookmarks