A
Andyk
How can I subtract one date and time from another and show the answer in hh:mm:ss
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Hi
You can just use B2-A2 and format the result as [hh]:mm:ss
--
Andy.
You can just use B2-A2 and format the result as [hh]:mm:ss
--
Andy.
hh:mm:ssAndyk said:How can I subtract one date and time from another and show the answer in
P
Pete McCosh
Andy,
right click the cell with the result of the formula,
select Format Cells > Number tab > Time > 37:30:55
Pete
right click the cell with the result of the formula,
select Format Cells > Number tab > Time > 37:30:55
Pete
B
Bob Phillips
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)
=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.
hh:mm:ssAndyk said:How can I subtract one date and time from another and show the answer in