Variable Symbol

[kashyap]

Hi, How to make + symbol variable in the below formula?
This formula is in G25 and symbol is in F25 has + & - symbols

=(NOW()-E$592)+E614

 

[Scott Huish]

because that will make a text string.

If you are adding times or dates together, use = E4+G4 and format as needed.

 

[kashyap]

Actually I was trying to add symbol and time..

 

[Scott Huish]

Assuming symbol in E4 and time in G4, something like this:

=E4&TEXT(G4,"[h]:mm")

 

[kashyap]

How to extract only time from -NOW() ? HOURS:MINUTE:SEC

 

[Scott Huish]

=mod(now(),1)

 

[kashyap]

Still i'm getting date as well

 

[Scott Huish]

Format the cell as time.

Excel Workbook
	D
1	3:02 PM
Sheet1

 

[kashyap]

Even though I format cell as time, in formula bar it shows date as well.. which I don't want..

is there any other option to get current time only..? (without date)