RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have 2 cells with values. One is formatted as 'general' (A1) and one with a 'custom' format - h"hrs" mm"m" (B1)
I need to concatenate the 2 together in (C1)
The value in (A1) is: "Time spent running: "
The Value in (B1) is: 0.0347, which after the formatting shows '0hrs 50m'
I was hoping to get a result in (C1) as: "Time spent running: 0hrs 50m"
but the actual result is "Time spent running: 0.0347"
I have found that if I change the formula in C1 to:
the result is "Time spent running: 0:50", but I really want "Time spent running: 0hrs 50m"...
Is there a way to combine my 2 cells, yet retain the formatting of my hours and mins?
If you can point me in the right direction, I'd be really grateful
Thanks
I need to concatenate the 2 together in (C1)
The value in (A1) is: "Time spent running: "
The Value in (B1) is: 0.0347, which after the formatting shows '0hrs 50m'
I was hoping to get a result in (C1) as: "Time spent running: 0hrs 50m"
but the actual result is "Time spent running: 0.0347"
I have found that if I change the formula in C1 to:
Code:
CONCATENATE(A1," - ",TEXT(B1, "h:mm"))
the result is "Time spent running: 0:50", but I really want "Time spent running: 0hrs 50m"...
Is there a way to combine my 2 cells, yet retain the formatting of my hours and mins?
If you can point me in the right direction, I'd be really grateful
Thanks