Get Time from Timestamp Data

[Steve001]

Hello Everyone,

There is loads of time related subjects on here when i searched, but trying to find what i wanted and one that worked was difficult.

I have data from a Data logger that timestamps data example as below

12/03/2024 15:49:13:179

to

15/03/2024 07:40:43:179

What i want to do

Get the total run time

Days
Hours
Minutes
Seconds

Please put comments in any example code so i can understand whats happening and why

Regards

Steve

 

[Dave Patton]

Custom Format I put the information in column D
Ctrl 1 Number Custom

T240203a.xlsm
	A	B	C	D
1	12/03/2024 15:49:13:179	12-Mar-2024 15:49:13	2 15:51:30	d hh:mm:ss
2	15/03/2024 07:40:43:179	15-Mar-2024 7:40:43
3		2.660763889
4		2 15:51:30		d hh:mm:ss
5		63 h 51 m 30 s		[h] "h" mm "m" ss "s"
6
2a

Cell Formulas
Range	Formula
C1	C1	=LEFT(A2,19)-LEFT(A1,19)
B1:B2	B1	=LEFT(A1,10)+SUBSTITUTE(RIGHT(A1,12),":",".",3)
B3	B3	=B2-B1
B4	B4	=B3
B5	B5	=B3

 

[Steve001]

Hi Dave,
Thank you i will have a go tomorrow

 

[Steve001]

Hi Guys,

Thanks for your help got it working now

Steve

 

[Dave Patton]

Thanks for the feedback.