HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES

's Computer Specifications

I HAVE A CELL WHICH IS IN TIME FORMAT WHICH I WANT TO CONVERT TO MINUTES AND
HAVE THE RESULT PUT IN ANOTHER CELL. FOR EXAMPLE I HAVE 10:00 (TO REPRESENT
10 HRS) AND NEED THIS CONVERTING TO MINUTES IN ANOTHER CELL. NO MATTER WHAT I
TRY I CAN'T GET IT TO SHOW 600. PLEASE CAN ANYONE HELP??

MANY THANKS

Eclaires

's Computer Specifications

With the time in A1 try:-

=A1*24*60

Ensure cell is formatted general.

Mike

"Eclaires" wrote:

> I HAVE A CELL WHICH IS IN TIME FORMAT WHICH I WANT TO CONVERT TO MINUTES AND
> HAVE THE RESULT PUT IN ANOTHER CELL. FOR EXAMPLE I HAVE 10:00 (TO REPRESENT
> 10 HRS) AND NEED THIS CONVERTING TO MINUTES IN ANOTHER CELL. NO MATTER WHAT I
> TRY I CAN'T GET IT TO SHOW 600. PLEASE CAN ANYONE HELP??
>
> MANY THANKS
>
> Eclaires

's Computer Specifications

=A1
format cell as [m]

"Eclaires" wrote:

> I HAVE A CELL WHICH IS IN TIME FORMAT WHICH I WANT TO CONVERT TO MINUTES AND
> HAVE THE RESULT PUT IN ANOTHER CELL. FOR EXAMPLE I HAVE 10:00 (TO REPRESENT
> 10 HRS) AND NEED THIS CONVERTING TO MINUTES IN ANOTHER CELL. NO MATTER WHAT I
> TRY I CAN'T GET IT TO SHOW 600. PLEASE CAN ANYONE HELP??
>
> MANY THANKS
>
> Eclaires

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to convert a decimal time to hours and minutes, is there a	Dave	Microsoft Access Queries	3	6th Nov 2008 11:20 PM
Converting Hours in decimal format to Hours and minutes (short time)	Gina	Microsoft Access	2	26th Sep 2007 05:42 PM
convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.	=?Utf-8?B?aGFyZCB3b3JraW5nIGFuZHkgdw==?=	Microsoft Excel Worksheet Functions	6	9th Aug 2007 04:38 PM
How do I convert hours, minutes, and seconds into decimal format?	=?Utf-8?B?UHJvZ3JhbW1lciBXYW5uYWJl?=	Microsoft Excel Worksheet Functions	2	13th May 2007 03:01 AM
Convert hours and minutes in time format into fractions of hours..	=?Utf-8?B?QWtlcm4=?=	Microsoft Excel Worksheet Functions	4	21st Apr 2005 02:56 PM