Converting time format in hours mins to minutes
I've tried converting say 02:30 (hr min) into minutes by using Custom format
mm ss - but it doesn't seem to work. What the correct way to do this? many thanks |
Converting time format in hours mins to minutes
[m]:ss
or [m] -- Kind regards, Niek Otten Microsoft MVP - Excel "Zakynthos" wrote in message ... | I've tried converting say 02:30 (hr min) into minutes by using Custom format | mm ss - but it doesn't seem to work. | | What the correct way to do this? | | many thanks |
Converting time format in hours mins to minutes
Many thanks - I did try that but it didn't work!!! only giving the minutes as
a result and ignoring the hours eg 02:30 was formatted as 30 I then tred a Google search as I needed the answer urgently and found that multiplying by 24 then by 60 then formatting result as whole number did the trick. "Zakynthos" wrote: I've tried converting say 02:30 (hr min) into minutes by using Custom format mm ss - but it doesn't seem to work. What the correct way to do this? many thanks |
Converting time format in hours mins to minutes
On Mar 23, 5:47 am, Zakynthos
wrote: Many thanks - I did try that but it didn't work!!! only giving the minutes as a result and ignoring the hours eg 02:30 was formatted as 30 I then tred a Google search as I needed the answer urgently and found that multiplying by 24 then by 60 then formatting result as whole number did the trick. "Zakynthos" wrote: I've tried converting say 02:30 (hr min) into minutes by using Custom format mm ss - but it doesn't seem to work. What the correct way to do this? many thanks- Hide quoted text - - Show quoted text - Try the "MINUTE" function in Excel. Search Excel Help "Minute" to see how it works exactly. If you go to Menu Bar: Insert/Function, and change the drop down box to "Date & Time" you'll see a number of time functions that are available to you. You shouldn't have to do x*24/60. Matt |
Converting time format in hours mins to minutes
Matt,
Thanks for your help on this - I really appreciate your comments - too late for today's work but I'll certainly use it on future occasions. Best wishes, Tony "matt" wrote: On Mar 23, 5:47 am, Zakynthos wrote: Many thanks - I did try that but it didn't work!!! only giving the minutes as a result and ignoring the hours eg 02:30 was formatted as 30 I then tred a Google search as I needed the answer urgently and found that multiplying by 24 then by 60 then formatting result as whole number did the trick. "Zakynthos" wrote: I've tried converting say 02:30 (hr min) into minutes by using Custom format mm ss - but it doesn't seem to work. What the correct way to do this? many thanks- Hide quoted text - - Show quoted text - Try the "MINUTE" function in Excel. Search Excel Help "Minute" to see how it works exactly. If you go to Menu Bar: Insert/Function, and change the drop down box to "Date & Time" you'll see a number of time functions that are available to you. You shouldn't have to do x*24/60. Matt |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com