Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss)

Posted to microsoft.public.excel.misc

illian Walsh

Posts: n/a

Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss)

Hi,

I have a Excel file with time values in a number of columns. The times are
in hh:mm (04:03) format but should be in mm:ss (04:03) format.

In other words, whenthe times were first entered they were put in as 04:03
and formatted as hh:mm. They should have been formated as mm:ss

When I try and change the format to mm:ss I get 03:00, I want 04:03

I hope this makes sence.

Thanks for your help.

Killian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert whole numbers representing seconds to mm:ss	Elvin	Excel Worksheet Functions	2	March 6th 06 05:49 PM
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?	Wesley Accellent	Excel Worksheet Functions	6	December 1st 05 07:03 PM
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?	Fernando	Excel Discussion (Misc queries)	1	December 1st 05 05:02 PM
How to convert 250minutes into the format of hh:mm:ss in Excel?	zhao	Excel Worksheet Functions	1	November 14th 05 06:18 AM
how to convert 357646 seconds into hh:mm:ss format?	Samantha	Excel Worksheet Functions	6	March 25th 05 04:11 PM

All times are GMT +1. The time now is 05:13 PM.

Menu

About Us