View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
evan evan is offline
external usenet poster
 
Posts: 64
Default Time difference function

I'm having problems finding the difference between to columns of time
formatted into mm:ss. The difference shows up as ##### So, I converted each
column of mm:ss into numbers with this formula: =TIMEVALUE(TEXT(I3,"hh:mm"))
such that 03:00 = 0.002083333, 02:04 = 0.086111111 the difference =
0.088194444 using format custom mm:ss to reconvert back to time is
07:00. Now I'm stuck just not sure which function I should use to correctly
reconvert the difference back into "mm:ss" Any help is greatly
appreciated.

Thanks EVan