PROBLEM WITH TIME CALCULATIONS

Closed
RASHMI - Mar 2, 2009 at 03:53 AM
Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 - Mar 2, 2009 at 04:33 AM
Hello,

Date Created Date Closed
17/02/2013 9:23:03 17/02/2013 10:28:03

These ar my two columns i need to calculate time in hours and time in days !!!
now by doing simple substraction i.e L2-M2 i get time in hours and the to get time in days i divide the time in hours by 24 ok!!!

i get the right answer if the time in hours is greater than 24:00 hrs ... but if the time in hours is 1 hours

Please help !!!!

This is in Excel 2003
URGENTLY

R@$H
Related:

1 response

Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 125
Mar 2, 2009 at 04:33 AM
There is a get and set time function for hours minute days etc like someDate.setMilliseconds(999) google it and you will find a tutorial on it
0