Thread: Calculate total time between two dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lloyd Lloyd is offline
external usenet poster
  
Posts: 41
Default Calculate total time between two dates
Hi
i first want to say thank you. I hope I explain myself.

A1. Sunday 23:00
B1. Monday 01:00

=Sum(B1-A1)
I am getting -22 hours

Thank you for your help
Reply With QuoteReply With Quote