• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert Date time difference to hh:mm:ss

Anubhav28

New Member
I have Coumn M and Column N as below
Start TimeEnd Time
2024-10-07 7:36:33 AM2024-10-07 7:45:10 AM

How can I populate the difference between end time and start time in hh:mm:ss format.

Don't need date or AM PM.. When i tried text to column and changing formats unable to do so.
 

Anubhav28

Basically = End_Time - Start_Time, if those times are (real) times.
If those are something else then please, send a sample Excel-file with some sample values that other could see - what are those?
 
I tried that.. i get result as
12:08:37 AM

Update -
I made some changes to the formatting and it worked now.
thanks
 
Last edited:
I think I made some progress there..
How can I convert and bucket these different time entries in 30 min interval buckets.. like 07:00-07:30, 07:30-08:00 and so on..
Start Time
7:36:33 AM
7:45:56 AM
8:12:55 AM
8:22:19 AM
8:24:20 AM
8:35:48 AM
8:42:06 AM
8:44:18 AM
8:52:05 AM
8:54:57 AM
8:57:35 AM
 
Start TimeEnd TimeDuration of call30 Min IntervalEnd within interval
7:36:33 AM7:45:10 AM0:08:37
What can be the formula or easiest way to get this?
What can be the formula or easiest way to get this?
7:45:56 AM7:53:14 AM0:07:18
8:12:55 AM8:28:33 AM0:15:38
 
=FLOOR.MATH(A2,1/48)
format as time.

Not sure what you want for the end time but maybe:
=CEILING.MATH(B2,1/48)
 
Back
Top