Thread: How do I get the difference between two times, including hundredth
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default How do I get the difference between two times, including hundredth
One way:

A1: 2:32.67
B1: 2:30.23
C1: = A1 - B1

Format C1 with Format/Cells/Number/Custom mm:ss.00

In article ,
"R-teast Loman" <R-teast wrote:

A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..
Reply With QuoteReply With Quote