Thread: Time difference function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
evan evan is offline
external usenet poster
  
Posts: 64
Default Time difference function
Just corrected a mistake, function is now =TIMEVALUE(TEXT(I3, "mm:ss")) such
that 3:00 = .125, 02:04 = .166666667 the difference = -0.41666667. So I have
a new problem a negative number. Is this more easily solved by converting
all time into seconds using 86400? Then my problem is how to convert the
seconds back to a mm:ss format. Already trid to format the column using
Format Custom mm:ss but it doesn't work.

"Evan" wrote:


Reply With QuoteReply With Quote