Hi there
I have an excel sheet that contain time duration values of days hours minutes seconds as follows on Column A
Note that some of the values just indicates hours minutes and seconds
2 03:32:37 - Need this to be converted to minutes in Column B = 3093
00:00:00 - This needs to display in Column B = 0
00:56:24 - This needs to display in Column B = 56
16:50:17 - This needs to display in Column B = 65
I tried the following:
In Column C:
=LEFT(A1,FIND(" ",A1)-1)*1440
In Column D:
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))*60*24
In Column B:
=C1+D1
I managed to convert the value 2 03:32:37 as in 2 (days) 03 (hours) 32 (mins) 37 (secs) to 3093 - which is the value that I want in minutes.
However, when i applied this formula to the rest of the rows, it just shows #VALUE instead of the correct values.
Is there any formula that can help solve my issue?
Edit:
Example3.xlsx attached as sample. There is a "Before" Sheet and "After" Sheet indicating what I've done (and failed) and what I want to achieve.
The formulas I used above is in "After" sheet.
Thanks alot in advance!
Bookmarks