View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wannano Wannano is offline
external usenet poster
 
Posts: 30
Default Elapsed Time Assistance

A2: 4/03/2007 2:15 PM (Start)
B2: 4/05/2007 7:00 PM (End)
C2: Need formula

I need a task measuring formula in C2 to capture the amount of time taken to
complete a specific task. Weekends do not count in this event. It might
sometime take longer than 24 hours to complete a task. I would like the
results to be in a h:mm format.

THANK YOU!

--
Texas Wannano