Help required
Nel ,
Hassan ha scritto:
Hi All,
A1 B1
Business hrs 06:00 AM
I have an excel sheet, with Business hrs in A1 and Time in B1, In F1
I want a Like that: Total Business hours from 06:00 AM, so this Time
here take from B1.
Thanks & Regards
Hi Hassan,
try this one in F1:
=A1&" "&TEXT(B1,"hh:mm AM/PM")
--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|