Remove everything AFTER string in Notepad++
i/p: srinivaskuamrgoud wants to delte after goud test and all
o/p: srinivaskuamrgoud
use below method.
Duration calc between two timestamps
Calculating time difference with the TEXT function Calculate hours between two times: =TEXT(B2-A2, "h") Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm") Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")
Comments
Post a Comment