Excel Time Calculation - TechRepublic
General discussion
June 14, 2002 at 04:10 AM
chainsawz

Excel Time Calculation

by chainsawz . Updated 24 years, 1 month ago

I am trying to calculate a time difference in Excel 97, and cannot get it to work. In cell A1 I have a ‘time in’ displayed in this format: 9/22/1991 8:03:00 AM, and a ‘time out’ in cell B2 (9/23/1991 9:05:00 AM). I need to display the differencebetween the ‘time in’ and ‘time out’ in Days, Hours, and Minutes. Help?!

This discussion is locked

All Comments