View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaveAsh DaveAsh is offline
external usenet poster
 
Posts: 49
Default Adding date/time in format dd/mm/yyyy hh/mm

I am struggling to subtract a start date/time cell from a finish date/time
cell. I can do it using the =sum function, but this gives the total hour
difference. I need to change this to working hours (those hours between 9&5),
any ideas??

Thanks