| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate the difference in weeks between two dates | Excel Worksheet Functions | |||
| calculate difference between two times | Excel Worksheet Functions | |||
| formula to calculate difference between dates and times | Excel Discussion (Misc queries) | |||
| NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR . | New Users to Excel | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Threaded Mode
