Thread
:
Formula to add text after a sum
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Formula to add text after a sum
You have two options:
1) =G365/60&" hrs"
2) = G365/60
FormatNumberCustomized
0,00" hrs"
Personnaly, I prefer #2
HTH
--
AP
"Robb @ FLW" a écrit dans le message de
news:
...
I have a time calculated cell for example =Sum(G2:G364) my result is 210
minutes, then I have another cell that divides it by 60 with a result of
3.5
I would like to add the hrs indicator behind this so that I will see 3.5
hrs
Thank you in advance for any assistance that you can provide
--
Robb
Reply With Quote