View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atri Atri is offline
external usenet poster
 
Posts: 12
Default Calculate the difference between two times and show dd:hh:mm:ss

Hello!

I use Excel version 2003 SP2 and have a question about calculating the
difference between two times. I have the two times in different cells and
use this formula to calculate: A1-B2=C2. I use the cell format time 37:30:55
in cell C2 and that works. The result is shown as for exampel 78:04:43
(hh:mm:ss). I want to show the result in days, hours, minuts and seconds.
Is there a format or function I can use to solve this problem? It is much
for user-friendly to show days, hours and minutes, in stead of only hours and
minuts. I will appreciate any help.
--
Atri