mercyat3pm
New Member
- Joined
- Apr 25, 2002
- Messages
- 9
how do you format a cell so that excel formats it as an amount of time, instead of an actual time? for example, i want to record a number "19:42" as 19 minutes and 42 seconds...not as 7:42pm. any suggestions?
thanks!
-mercyat3pm-
thanks!
-mercyat3pm-