View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
Jay[_15_] Jay[_15_] is offline
external usenet poster
 
Posts: 6
Default Complicated Time Formula

Wow thank you for all the help.
What my utilmate goal is to determine a utilization ratio
for an ambulance service I.e. if an ambulance was on a
call from 23:15 to 00:15, I want to be able to show that
that ambulance was active for 75% of the 23:00 time block
and 25% of the 00:00 time block. This easy to do when
dealing with one call, but I am dealing with several
thousand over a month long period. Once I am able to
determine the amount of time spent on each call in each
time block the rest is very easy to complete. Thank you
again. You guys have been great. The main hang up is the
00:00 time block.

Jay