Helen.Winder
New Member
- Joined
- Apr 24, 2003
- Messages
- 30
Is there a formula that will convert time format from minutes and seconds to Hours, minutes and seconds. I have some stats from Crystal Reports that are in minutes and seconds format (i.e 01:02, 1 minute & 2 seconds). I paste this into excel and compare the times with other stats that are in hours, minutes & seconds format (i.e 00:01:02, 0 hrs, 1 minutes & 2 seconds). At the moment I am having to overtype the cell to convert it in to the hours minutes & second format but wondered if there was a forumula I could set up that would do this for me.