Thread: Formula needed to calculate difference between Two dates and times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Abee Abee is offline
external usenet poster
  
Posts: 1
Default Formula needed to calculate difference between Two dates and times
I want to know the formula for calculating the below mentioned problem
col A B C
1 10.8.08 11 AM 11.8.08 3PM 2days ( i need formula here)

We have a small inn and i need to calculate the duration of stay by a guest.
Checkout time is 24 Hrs. The Column C should display 1 if the duration is
less than 24 Hrs and it should display 2 if its more than 24 and less than 48
and so on. PLEASE HELP

Reply With QuoteReply With Quote