View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES

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