Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time Difference Excel
- Thread starter Gootz11
- Start date
TonyJollans
Programmer
Hi Gootz11,
Times are just numbers, so subtraction is all you need, after which you format the results as you want, so ..
Assuming your times are in A1 and B1, put the same formula in both C1 and D1 .. [blue]=B1-A1[/blue]
Then format C1 as [blue][ss][/blue]
and format D1 as [blue][mm][/blue]
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Times are just numbers, so subtraction is all you need, after which you format the results as you want, so ..
Assuming your times are in A1 and B1, put the same formula in both C1 and D1 .. [blue]=B1-A1[/blue]
Then format C1 as [blue][ss][/blue]
and format D1 as [blue][mm][/blue]
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
SkipVought
Programmer
Hi,
Just to add to what Tony has stated, Time Value UNITS are in DAYS. Time is the FRACTIONAL part of Date/Time. Your 2 Time Values are 0.375 0.7625.
Just be aware
;-)
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
Just to add to what Tony has stated, Time Value UNITS are in DAYS. Time is the FRACTIONAL part of Date/Time. Your 2 Time Values are 0.375 0.7625.
Just be aware
;-)
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
- Status