How can i find the time difference from like "910:30" formatted cell.What is the formula to find the "1.5" hour or "90" minutes from that cell.
migrated from stackoverflow.com Apr 9 '13 at 15:41This question came from our site for professional and enthusiast programmers. 


I'd advise you, if possible, to put the two time values in separate cells, e.g. 09:00 in A2 and 10:30 in B2 then use this formula in C2
format C2 as number to see 1.5 to get 90 replace 24 in the formula with 1440 If you can't split the data but can make it consistent like 09:0010:30 or 15:3019:15 (with times always shown as 5 characters including ":") then you can use this formula



Assuming this value is in


