Calculate Time Between Dates

1 minute read Download the example workbook here: calculate-time-between-dates.xlsx Calculating hours, minutes and seconds between two times =IF(B2< A2, 1 + B2 – A2, B2- A2) Number Format: h:mm:ss Calculate days To calculate elapsed days is so easy, you just need to apply this formula Number Format: Calculate Days, Hours and Minutes To calculate and … Read more