View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Davidt Davidt is offline
external usenet poster
 
Posts: 9
Default How do I summarize total hours over multiple days

EXCEL 2003- How can I modify
"=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add
up total hours over multiple days with a start time in one cell and end time
in another cell. And how do I link those cells to a date.