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

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

Hassan wrote:
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.

Please restate "In F1 I want a Like that: .."

If B1='06:00 AM and C1 = '07:02 PM then
F1= =HOUR(B1-A1)&":"&MINUTE(B1-A1)&":"&SECOND(B1-A1)
gives elapsed time 13:2:0.

Is there a sheet equivalent of Format$() function?



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----