Posted by david m on February 11, 2002 7:41 AM
2 questions related to time:
1. Is there a way to format a cell so that a data entry operator only enters numbers (no colons) in a cell, and Excel returns a military time based on those numbers? For example, I'd like to enter 740 and have Excel return 07:40 or enter 1345 and have Excel return 13:45.
2. Is there a formula that can calculate in minutes the difference between two cells that contain time values? For example, if A1 is 13:30 and B1 is 16:45, is there a formula for C1 that would return 75 minutes?