Urgent - Time function question

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

Hello -

I have a report that was imported into Excel from Crystal
Reports.

Within the report, there is a time field that displays
hours, minutes and seconds. I would like for this field
to only display the time in minutes and seconds.

Is there a way to convert the time from hours, minutes and
seconds into only minutes and seconds? For example, if
the time is 2 hours, 30 minutes and 30 seconds, I would
like for it to display as 150 minutes, 30 seconds.

[Even better, if anyone knows how to change this field in
Crystal Reports, that would be wonderful; however, I will
be ok with doing it like this in Excel.]

Any ideas on how to do this? Hope this makes sense.

Thanks!
 
Hi Carol,

For the first part, try:

Format > Cells > Custom

and use [m]:ss as your custom format.

Hope this helps!
 
Back
Top