Solved: Need help on duration calculation - Page 4

Vishal2009 · 03-Mar-2009, 07:14 AM **#46**

If you look at cell no A92, ticket raised at 2/5/2009 5:16:13 PM and accepted at 2/5/2009 5:22:29 PM is giving the response time as 5:22:29.

Aj_old · 04-Mar-2009, 08:45 AM **#47**

Quote:

Originally Posted by Vishal2009

If you look at cell no A92, ticket raised at 2/5/2009 5:16:13 PM and accepted at 2/5/2009 5:22:29 PM is giving the response time as 5:22:29.

Vishal, I opened the file and the resul in row 92 is 0:06:29 not 5:22:29.?

Vishal2009 · 15-Mar-2009, 05:38 AM **#48**

Hi AJ, sorry it took me long to respond to your comment, i tried opening the excel at different locations to make sure if its my computer that is giving wrong output but the results are the same. I saw the screenshot you posted and you are correct but i am not able to get those results up on my screen. You have any suggestion on this?

Vishal2009 · 15-Mar-2009, 06:03 AM **#49**

I have attached the screenshot here,

Vishal2009 · 15-Mar-2009, 07:00 AM **#50**

The only difference AJ, i could figure out in the formula is, in your screenshot its showing ";" whereas in mine its "," and the display formats of the dates. I am sure i am missing something very basic but i am stumped and cant think of anything...

Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!