count out minutes

[John-SSI]

Hi, 

I want to have a variable so i can remove minutes from a calculated time.

The time is: HH:MM:SS, and i want to remove 40 min (00:40:00) 

so : 05:40:00, then remove 40 minutes the time should be 05:00:00

Doable?

Br John

[robert_mika]

=MakeTime(left('05:40:00',2),0,0)

or

=MakeTime(left( yourdim,2),0,0)

[Vegar]

Do you always want to remove 40 minutes from  time or do you want to ignore the minutes and the second part of  the time values.

Alternative 1: Time(time_value - interval#(40,'m'))

Alternative 2: maketime(hour(time_value))

[John-SSI · Accepted solution]

Hi, i want it as a varible and have an option to change the value, but i think i found it.:)

[Vegar]

@John-SSI 

Great that you found the solution for you problem.

Is it possible for you to post it here and mark it as the solution? Your solution might be helpful for future community users having a similar problem.

Thanks!