compare time and add 5 minutes...

[jamiguel77]

hi friends have a problem i have 2 sheets, 1 named "TELCEL" and other named OMNITEL in sheet TELCEL i have in column B the time

Please Login or Register  to view this content.

when i inspect wtiempo variable i get value: 0.377916666666667 and the cell have 17:34 then the question is how add 5 minutes to wtiempo variable?

17:34 + 5 would be 17:39

thanks

[Leith Ross]

Hello jamiguel77,

Use the TimeSerial function to add the minutes. The function takes the hours, minutes, and seconds you give it and converts into a system time value. The values are integers.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[jamiguel77]

error, creating a new thread.