G Guest Apr 16, 2004 #1 How can I subtract one date and time from another and show the answer in hh:mm:ss
A Andy B Apr 16, 2004 #2 Hi You can just use B2-A2 and format the result as [hh]:mm:ss -- Andy. Andyk said: How can I subtract one date and time from another and show the answer in Click to expand... hh:mm:ss
Hi You can just use B2-A2 and format the result as [hh]:mm:ss -- Andy. Andyk said: How can I subtract one date and time from another and show the answer in Click to expand... hh:mm:ss
P Pete McCosh Apr 16, 2004 #3 Andy, right click the cell with the result of the formula, select Format Cells > Number tab > Time > 37:30:55 Pete
Andy, right click the cell with the result of the formula, select Format Cells > Number tab > Time > 37:30:55 Pete
B Bob Phillips Apr 16, 2004 #4 But you might need to cater over midnight =MOD(B2-A2,1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Andy B said: Hi You can just use B2-A2 and format the result as [hh]:mm:ss -- Andy. Andyk said: How can I subtract one date and time from another and show the answer in Click to expand... hh:mm:ss Click to expand...
But you might need to cater over midnight =MOD(B2-A2,1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Andy B said: Hi You can just use B2-A2 and format the result as [hh]:mm:ss -- Andy. Andyk said: How can I subtract one date and time from another and show the answer in Click to expand... hh:mm:ss Click to expand...
