I have an excel spreadsheet that contains fields such as Date in, time in, date out, time out. The date format is mm/dd/yy and the time format is hh:mm:ss. There can be multiple days in between. I am looking for a formula that will calculate the amount of time for each. All that I can find are formulas that take into account the after midnight problem. I need to do this in Excel and in Crystal. I am using Crystal Reports XI and Win XP with Excel 2003. Any help or advice is appreciated. Thanks....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time lapse formula for Excel or Crystal
- Thread starter kenp705
- Start date
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question