ote:
>
>
> From: JosephJoseph
>
> Subject: $$Excel-Macros$$ Time calculation help
> To: excel-macros@googlegroups.com
> Date: Monday, March 18, 2013, 1:30 AM
>
>
> Hello Everyone
>
> I am trying to add & or subtract hours to or from time..
>
> In cell 1a show
Hi,
A1
0.6875
B1
=1.5/24
=A1+B1
0.6875
=1.5/24
=A2-B2
Please convert the A1 into numbers
--- On Mon, 3/18/13, JosephJoseph wrote:
From: JosephJoseph
Subject: $$Excel-Macros$$ Time calculation help
To: excel-macros@googlegroups.com
Date
ong as ever you can.” - John Wesley
-
From: JosephJoseph
To: excel-macros@googlegroups.com
Sent: Sun, March 17, 2013 4:00:53 PM
Subject: $$Excel-Macros$$ Time calculation help
Hello Everyone
I am trying to add & or subtract hours to or from time..
Use 1A+1B/24
On Monday, 18 March 2013, JosephJoseph wrote:
> Hello Everyone
>
> I am trying to add & or subtract hours to or from time..
>
> In cell 1a showing 4:30 PM & Cell 1b shows hours like 1.5 hours or 2
> hours or 3.5 hours..
>
> I need to add cell 1b 1.5 hours to cell 1a 4:30 PM to get a
Hello Everyone
I am trying to add & or subtract hours to or from time..
In cell 1a showing 4:30 PM & Cell 1b shows hours like 1.5 hours or 2 hours
or 3.5 hours..
I need to add cell 1b 1.5 hours to cell 1a 4:30 PM to get a result of 6:00
pm.
I tried =1a+1b and that did not work.
*Also need t
Greetings,
I need a formula that calculates the amount of time between 7pm and 6pm and
the entire weekend between 2 dates. Example:
A1 = End Date and Time 8/1/2012 12:00:00PM
B1 = Start Date and Time 8/21/2012 4:00:00PM
I need the result to be in hh:mm:ss.
Thanks in advance.
Dear Sunder,
Please use..
*=IF(A3=TIMEVALUE("10:00:00 AM"),"Meet the TAT",IF(A3=TIMEVALUE("03:00:00
PM"),"Not Meet the TAT",""))*
On Thu, Jul 19, 2012 at 1:02 PM, Sundarvelan N wrote:
> Hi Friends,
>
> Please help me in calculating the TAT
>
> If my registration is 9 A.M
>
> and the despatch t
Hi ,
Kindly use below formula.
despatch Time
Acutal despatch Time
TAT Status
Formula 7/18/12 9:00 AM 7/18/12 10:00 AM TAT Meet =IF(TEXT(C2,"hh")="10","TAT
Meet","TAT not Meet") 7/18/12 9:00 PM 7/18/12 3:00 PM TAT not Meet
=IF(TEXT(C3,"hh")="10","TAT
Meet","TAT not Meet")
Regards
Amre
Hi Friends,
Please help me in calculating the TAT
If my registration is 9 A.M
and the despatch time is 10 A.M - Met the TAT
IF the despatch time is 3 P.M - Not Me the TAT
Thanks
N.Sundarvelan
9600160150
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate th
Hi Noorain,
Thanks for resolving the query. Now i got the correct result.
Regards
Lokesh.M
On Thu, Jul 12, 2012 at 9:04 AM, NOORAIN ANSARI wrote:
> Dear Lokesh,
>
> Please find the attached sheet, Hope it will help to you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
>
Dear Lokesh,
Please find the attached sheet, Hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 12, 2012 at 8:21 AM, Lokesh Loki wrote:
> Hi All,
>
> Please find the attached excel sheet and i need formula for tot
Hi All,
Please find the attached excel sheet and i need formula for total time
taken.
Let me know for any clarification.
Regards
Lokesh.M
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Try this:
=TEXT((C7+D7)-(A7+B7),"[H]:mm:ss")
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: Apr/Sat/2012 06:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Time calculation sheet
Hi Experts
*Hi Experts,
I have attached the file which i am unable to calculate the time
sheet. please help me out to sort out. thanks in advance.
*
Thanks & Regards,*
*
*Deba Ranjan P***
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thre
Sam,
Thank you for that, it saves a column.
John
On Wed, Nov 2, 2011 at 9:25 PM, Sam Mathai Chacko wrote:
> If you only want the finish time without splitting it in to Date and Time,
> you could also use
>
> =LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),"00\:00")+(B23/(60*24)) in
> mm/dd/ hh:
Haseeb,
Thank you for that. That solved an unrelated issue and was very helpful,
thank you.
John
On Wed, Nov 2, 2011 at 8:22 PM, Haseeb Avarakkan wrote:
> Hello John,
>
> If the Arrival Date & Time is "09/08/2011 2310" & Length is 343 (Row 3
> data) Finish date & time is 09/09/2011 04:53. Arr
If you only want the finish time without splitting it in to Date and Time,
you could also use
=LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),"00\:00")+(B23/(60*24)) in
mm/dd/ hh:mm format
Regards,
Sam Mathai Chacko
On Thu, Nov 3, 2011 at 5:52 AM, Haseeb Avarakkan wrote:
> Hello John,
>
> If
Ashish,
Wonderful. Works just as I need. Thank you for your continued help.
John
On Wed, Nov 2, 2011 at 9:02 AM, ashish koul wrote:
> see if it helps
>
>
>
>
> On Wed, Nov 2, 2011 at 4:38 PM, John A. Smith wrote:
>
>> I receive a download which shows Arrival Time as “09/14/2011 0938” and I
>
> excel-mac...@googlegroups.com] *On Behalf Of *Pankaj Kumar
> *Sent:* Saturday, September 25, 2010 4:33 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Time calculation
>
>
>
> Hi, Experts
>
>
>
> I have a problem my worksheet is attched , i have to calcul
Use this
=TEXT((C3-B3);"[h]:mm")
It is working
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pankaj Kumar
Sent: Saturday, September 25, 2010 4:33 PM
To: excel-macros
Subject: $$Excel-Macros$$ Time calculation
Hi, Experts
I have a
Hi, Experts
I have a problem my worksheet is attched , i have to calculated total
working hrs, pls help me
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
* rajputpankaj1...@rediffmail.com*
--
--
21 matches
Mail list logo