=DateTime2 - DateTime1 Format result as [h], or [h]:mm --ron
A Alok May 12, 2005 #2 Hi Iartis Say A1 has the starting Time/Date and A2 has the ending Time/Date then the following formula will give you the number of hours A2 occurs after A1 =(A2-A1)*24 Just remember to format as General the cell in which you enter this formula. Alok Joshi
Hi Iartis Say A1 has the starting Time/Date and A2 has the ending Time/Date then the following formula will give you the number of hours A2 occurs after A1 =(A2-A1)*24 Just remember to format as General the cell in which you enter this formula. Alok Joshi
