Hello, Is there a formula to count the total of hours between : 3-Feb-2004 14:20 to 4-Feb-2004 15:30
J Joyce Feb 17, 2004 #1 Hello, Is there a formula to count the total of hours between : 3-Feb-2004 14:20 to 4-Feb-2004 15:30
R Ron Rosenfeld Feb 17, 2004 #3 Hello, Is there a formula to count the total of hours between : 3-Feb-2004 14:20 to 4-Feb-2004 15:30 Click to expand... If the later date/time is in A2; and the earlier one in A1, then =A2-A1 To display it, either format the cell as [h]:mm to display in hours and minutes; or multiply by 24 to display in decimal hours. =(A2-A1)*24) --ron
Hello, Is there a formula to count the total of hours between : 3-Feb-2004 14:20 to 4-Feb-2004 15:30 Click to expand... If the later date/time is in A2; and the earlier one in A1, then =A2-A1 To display it, either format the cell as [h]:mm to display in hours and minutes; or multiply by 24 to display in decimal hours. =(A2-A1)*24) --ron
