Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate the difference between two times - getting '#VALUE!' err | Excel Worksheet Functions | |||
calculate difference between two times | Excel Worksheet Functions | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Calculate the difference two times | Excel Discussion (Misc queries) |