G Guest May 14, 2004 #1 I would like to know how to calclate date and time "01-02-2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
I would like to know how to calclate date and time "01-02-2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
F Frank Kabel May 14, 2004 #2 Hi if both values are in A1 and B1 enter the following formula =B1-A1 and format this cell with the custom format [hh]:mm -----Original Message----- I would like to know how to calclate date and time "01-02- Click to expand... 2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
Hi if both values are in A1 and B1 enter the following formula =B1-A1 and format this cell with the custom format [hh]:mm -----Original Message----- I would like to know how to calclate date and time "01-02- Click to expand... 2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
