ExcelBanter - HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES (https://www.excelbanter.com/excel-worksheet-functions/149451-how-convert-time-format-hours-minutes.html)

Eclaires

HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES

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

Mike H

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

Teethless mama

HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES

=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

All times are GMT +1. The time now is 09:56 AM.