Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default Change time

I understand that Excel always assumes the first unit of the time value is
hour. Example: If I enter 3:21, it means 3 hours and 21 minutes.

My problem is that I have lot of time data downloaded from another program
into Excel. The time is not displaced as I wish. Example: The information
3:21 should be 3 minutes and 21 seconds. Since the leading value of the hour
as 0 was not included, Excel assumes it's 3 hours and 21 minutes.

Can you think of any way that I can quickly change the data from hh:mm to
mm:ss?

Thanks in advance.

Anne
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
change date based on time kdp145 Excel Discussion (Misc queries) 7 December 14th 05 02:05 AM
Can series tool change formulas over time when used to copy them compu_trainer Excel Worksheet Functions 3 May 26th 05 07:55 PM
change format for time value Qaspec Excel Discussion (Misc queries) 1 May 23rd 05 10:25 PM
HOW CAN I CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME? DEMONET48 Setting up and Configuration of Excel 0 January 14th 05 07:53 PM
Calculate change over time Gwen Excel Worksheet Functions 0 January 1st 05 05:52 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"