google spreadsheet time spend concatenate

1
votes

I have a google spreadsheet that has a time calculation in it. The calculation gets the hours and minutes between two different time stamps. It can exceed 24 hours. The issue is when I want to concatenate the result with a different piece of text.

For example. The time is 51:55. When I concatenate it like

=CONCATENATE("The time spend will be";text(Input!E13;"hh:mm");

It results in The time spend will be 03:55.

I can not seem to find a way to exactly copy the text. If I just copy the text I get something like 2.1205154.

1
google-sheetstimeconcatenationgoogle-sheets-formuladuration

1 Answers

1
votes

try:

="The time spend will be "&TEXT(Input!E13; "[hh]:mm")