convert hours into minutes
I searched and found a question just like mine but the answer did not work
for me. here is waht I have: A1 21:05 A2 22:10 A3 =A2-A1 result 1:05 I want to convert the 1 hout and 5 minutes to 65 minutes. Thank you. |
Change the format of the cell with the formula in it to [m]. You can do this
by going to Format | Cells | Number. Choose Custom and type [m] in the line provided -- tj "Tony" wrote: I searched and found a question just like mine but the answer did not work for me. here is waht I have: A1 21:05 A2 22:10 A3 =A2-A1 result 1:05 I want to convert the 1 hout and 5 minutes to 65 minutes. Thank you. |
Put in as, in A3: =(A2-A1)*24*60
Format A3 as general or number -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Tony" wrote in message ... I searched and found a question just like mine but the answer did not work for me. here is waht I have: A1 21:05 A2 22:10 A3 =A2-A1 result 1:05 I want to convert the 1 hout and 5 minutes to 65 minutes. Thank you. |
Excellent, Thank you.
"Max" wrote: Put in as, in A3: =(A2-A1)*24*60 Format A3 as general or number -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Tony" wrote in message ... I searched and found a question just like mine but the answer did not work for me. here is waht I have: A1 21:05 A2 22:10 A3 =A2-A1 result 1:05 I want to convert the 1 hout and 5 minutes to 65 minutes. Thank you. |
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Tony" wrote in message ... Excellent, Thank you. |
All times are GMT +1. The time now is 03:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com