topic Re: Time Span - Date Time to Time conversion in Product Forum

Time Span - Date Time to Time conversion

DipinDevP — Wed, 16 Oct 2024 08:04:42 GMT

Hi,

I have two date times, say Date Time 1 = 03-09-2024 08:19:04 and Date Time 2 = 10-09-2024 21:18:15

I need to do a calculation Date Time 1 - Date Time 2. Currently I am getting output as 7.12:59:11 - I understand here 7 is day, 12 Hours, 59 minutes and 11 seconds.

I need the result in hours:minutes:seconds format - 180:59:11 (24X7 +12 = 180 hours).

Is there any way to achieve this, other than split and use Create date time method?

Thanks,

Dipin Dev P

Re: Time Span - Date Time to Time conversion

Denis__Dennehy — Wed, 16 Oct 2024 08:31:40 GMT

Top of my head, I'd probably store the the time as text, then play around with the text left/mid functions to isolate the days and hours and store them into number fields, multiply them, then join everything together in a string in the new format you want. There probably is a nicer way but things like this are not worth spending too long over as the time improvements at runtime would be microseconds.

Re: Time Span - Date Time to Time conversion

Mohamad_Dakkouri — Wed, 16 Oct 2024 08:39:38 GMT

@DipinDevP Hello

Try this :

DateDiff(7, [Data1], [Data2])&Mid([Data1]- [Data2],InStr([Data1]- [Data2],":"),Len([Data1]- [Data2]))

Re: Time Span - Date Time to Time conversion

Mohamad_Dakkouri — Wed, 16 Oct 2024 08:58:40 GMT

@DipinDevP it worked for you ?

please put best answer if yes 🙂

Re: Time Span - Date Time to Time conversion

DipinDevP — Wed, 16 Oct 2024 09:11:30 GMT

@Denis__Dennehy @Mohamad_Dakkouri Thanks for your quick response, both suggestions helped me a lot!

@Mohamad_Dakkouri Yes. It is worked. 🙂