May 22 2022 08:20 AM
Hi,
I need to be able to subtract date in the following format <day> <hour>:<minute>:<second>
Customer placed order datetime | Placed order with restaurant datetime |
01 02:52:12 | 01 03:00:25 |
May 22 2022 08:37 AM
Excel Formula: Calculate Days Hours Minutes seconds between Two Dates
=INT(C3-B3)&" days "&TEXT(C3-B3,"h"" hrs ""m"" mins ""s"" secs""")
or
Calculate the difference between two times
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
May 22 2022 08:43 AM
SolutionDear @Kristy_Zim
It is a little tricky to understand what you are after exactly.
However, if I assume that:
Then you can use something like this:
=TEXT(VALUE("2022-01-"&B2)-VALUE("2022-01-"&A2),"dd HH:mm:ss")
May 22 2022 09:01 AM
Yes, that's what I was looking for. Thank you very much for your help!!
May 22 2022 12:48 PM
May 23 2022 04:22 AM
If all times are within one date you may separate the column using Data->Text to Columns with space as delimiter. Or convert it to datetime by formula as previously discussed.
May 22 2022 08:43 AM
SolutionDear @Kristy_Zim
It is a little tricky to understand what you are after exactly.
However, if I assume that:
Then you can use something like this:
=TEXT(VALUE("2022-01-"&B2)-VALUE("2022-01-"&A2),"dd HH:mm:ss")