Skip to Content (Press Enter)
2019-10-04 15-01-22
Dhiraj Manwani
945Views
4Comments
Solved
Add time(hh:mm:ss)
Question

Hi all,


I have a query regarding time datatype.

I  want to add two variables with time datatype of the format hh:mm:ss, and get the sum of two time variables.

Is there any way to do this?



Thanks in advance :)

0
0
22 Jan 2020
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
Solution

I see two ways.


Working in datetime

you have functions to add hours, minutes and seconds. You just need to use all three.

AddSeconds(AddMinutes(AddHours(Date1,Hour(Date2)),Minute(Date2)),Second(Date2)))

Disadvantages: 25 hours will look like 1 day and 1 hour. You need to transform that bit.


Working in time

You have NewDate. If you build it piece by piece you get the time you want.

NewDate(Hour(Date1)+Hour(Date2),Minute(Date1)+Minute(Date2),Second(Date1)+Second(Date2))


Which one do you prefer?

See solution in context
4
0
22 Jan 2020
Copy Link
2019-10-04 15-01-22
Dhiraj Manwani

Nuno Reis wrote:

I see two ways.


Working in datetime

you have functions to add hours, minutes and seconds. You just need to use all three.

AddSeconds(AddMinutes(AddHours(Date1,Hour(Date2)),Minute(Date2)),Second(Date2)))

Disadvantages: 25 hours will look like 1 day and 1 hour. You need to transform that bit.


Working in time

You have NewDate. If you build it piece by piece you get the time you want.

NewDate(Hour(Date1)+Hour(Date2),Minute(Date1)+Minute(Date2),Second(Date1)+Second(Date2))


Which one do you prefer?

Thanks Nuno, the second worked for me :)


0
0
23 Jan 2020
Copy Link
2026-02-05 15-36-36
Lenon Manhães Villeth
Champion

Hi, dude.

I think that the best way is using a string split on the first variable and then sum the values one by one with the built-in-function add days, minutes, etc.

0
0
22 Jan 2020
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
Solution

I see two ways.


Working in datetime

you have functions to add hours, minutes and seconds. You just need to use all three.

AddSeconds(AddMinutes(AddHours(Date1,Hour(Date2)),Minute(Date2)),Second(Date2)))

Disadvantages: 25 hours will look like 1 day and 1 hour. You need to transform that bit.


Working in time

You have NewDate. If you build it piece by piece you get the time you want.

NewDate(Hour(Date1)+Hour(Date2),Minute(Date1)+Minute(Date2),Second(Date1)+Second(Date2))


Which one do you prefer?

4
0
22 Jan 2020
Copy Link
2019-10-04 15-01-22
Dhiraj Manwani

Nuno Reis wrote:

I see two ways.


Working in datetime

you have functions to add hours, minutes and seconds. You just need to use all three.

AddSeconds(AddMinutes(AddHours(Date1,Hour(Date2)),Minute(Date2)),Second(Date2)))

Disadvantages: 25 hours will look like 1 day and 1 hour. You need to transform that bit.


Working in time

You have NewDate. If you build it piece by piece you get the time you want.

NewDate(Hour(Date1)+Hour(Date2),Minute(Date1)+Minute(Date2),Second(Date1)+Second(Date2))


Which one do you prefer?

Thanks Nuno, the second worked for me :)


0
0
23 Jan 2020
Copy Link
2023-01-23 11-28-40
TradeLabel Software

I think you should use DateInterval class, may be it is possible.

0
0
24 Jan 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.