What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

true power of MS excel. update: PowerBI

Re: MS excel reportings, presentations, and vba helping thre

kirby21 said:
di ko kaya yan bro. hehehe. suko ako dyan.
Click to expand...

hehehe, sana meron maka pag share kung pano gawin yon sa vba.. salamat po sir..
 
Re: MS excel reportings, presentations, and vba helping thre

dannyps2 said:
hehehe, sana meron maka pag share kung pano gawin yon sa vba.. salamat po sir..
Click to expand...

pero yung author kinuha nya sa .net eh. :lol:
 
Re: MS excel reportings, presentations, and vba helping thre

dannyps2 said:
galing kasi, possible kaya pwedi rin sa vba yon?
Click to expand...

pwede naman siguro. deeper knowledge siguro. ibig sabihin di pa tayo magagaling. hehehe

para sa mga gusto magsimula mag programming.ito ang best book. i started with this book. while studying gumawa ng mga projects at tumambay dito. its much easier to digest the book that way.

http://filepi.com/i/brhLZjJ
 
Last edited:
Re: MS excel reportings, presentations, and vba helping thre

kirby21 said:
pwede naman siguro. deeper knowledge siguro. ibig sabihin di pa tayo magagaling. hehehe

para sa mga gusto magsimula mag programming.ito ang best book. i started with this book. while studying gumawa ng mga projects at tumambay dito. its much easier to digest the book that way.

http://filepi.com/i/brhLZjJ
Click to expand...

Thanks for sharing sir..
 
Re: MS excel reportings, presentations, and vba helping thre

thanks ts!! magaling magturo si TS.. :) :) keep it up
 
Re: MS excel we give solutions. formula, codes and tutorials

Good Morning sir,

Paturo naman ng formula for subtracting time.

eto kc yong nangyayari sir pagnagsusubtract aq ng time:

7:00 pm - 7:00 am = 12:00 which is correct but if
7:00 am - 7:00 pm = ############

Gusto q lang mkuha yung total difference ng two time for payroll entries using a formula_
pwede sanang isaisahin qng kunti lang yong cocomputin but for 500 plus employee mdjo mahirap.
may dayshift at pangnight shift kc kming employee.. sana mtulungan nyo aq.

Thanks in advance!

:praise:

bossaboss
 
Re: MS excel we give solutions. formula, codes and tutorials

tim mckey said:
Good Morning sir,

Paturo naman ng formula for subtracting time.

eto kc yong nangyayari sir pagnagsusubtract aq ng time:

7:00 pm - 7:00 am = 12:00 which is correct but if
7:00 am - 7:00 pm = ############

Gusto q lang mkuha yung total difference ng two time for payroll entries using a formula_
pwede sanang isaisahin qng kunti lang yong cocomputin but for 500 plus employee mdjo mahirap.
may dayshift at pangnight shift kc kming employee.. sana mtulungan nyo aq.

Thanks in advance!

:praise:

bossaboss
Click to expand...


Dapat yung value of dates nung dalawang cell mo is complete date talaga,
ex.

A1 = 05/28/2014 07:00 AM
A2 = 05/28/2014 07:00 PM
A3 = A2-A1 - will give you 12:00


Format mo nalang yung A1 and A2 to short time.

Quick solution lang yan,
Other way around is gamitan ng ibang function like Hour() and Minute()
 
Re: MS excel we give solutions. formula, codes and tutorials

knives645 said:
Dapat yung value of dates nung dalawang cell mo is complete date talaga,
ex.

A1 = 05/28/2014 07:00 AM
A2 = 05/28/2014 07:00 PM
A3 = A2-A1 - will give you 12:00


Format mo nalang yung A1 and A2 to short time.

Quick solution lang yan,
Other way around is gamitan ng ibang function like Hour() and Minute()
Click to expand...

bilis mo talaga. :lol:

tama si knives. agree ako sa sagot nya.
 
Re: MS excel we give solutions. formula, codes and tutorials

kirby21 said:
alam ko yung date nilagyan ko ng formula na =now() kaya automatic na yung date nun. naeedit naman sila lahat. inayos ko lang yung button para di ka na magedit ng form number mo.
Click to expand...

hindi bro eh maglalagay ka pa ng date.. :) ask ko na rin kung pwd ko ishare ung file? kasi di nagpiprint pag shineyr ko eh.. :)
 
Re: MS excel we give solutions. formula, codes and tutorials

rosslex said:
hindi bro eh maglalagay ka pa ng date.. :) ask ko na rin kung pwd ko ishare ung file? kasi di nagpiprint pag shineyr ko eh.. :)
Click to expand...

lagyan mo nalang ng formula na =now() pwede pero dapat one at a time lang ang pagbukas ng file. di pwedeng sabay kayo nakabukas. problema kasi natin is yung pag update eh.
 
Re: MS excel we give solutions. formula, codes and tutorials

Good Afternoon Sir,

Ganito poh kc yung nkukuha qng answer and ganito yung format ng payroll ko.
Patulong nman sir, Gusto ko pong mkuha yung manhours.

Thank you!
 

Attachments

  • Payroll Sample.rar
    13.5 KB · Views: 25
Re: MS excel we give solutions. formula, codes and tutorials

tim mckey said:
Good Afternoon Sir,

Ganito poh kc yung nkukuha qng answer and ganito yung format ng payroll ko.
Patulong nman sir, Gusto ko pong mkuha yung manhours.

Thank you!
Click to expand...

Inapply ko lang yung instructions ko from my previous post.
 

Attachments

  • Payroll Sample.zip
    13.9 KB · Views: 59
Re: MS excel we give solutions. formula, codes and tutorials

Boss Knives645,

Thank you sa Formula.
ok poh yung result pero di na madistinguish kung night shift or day shift.

If in is before 7:00am up to 3:00pm Dayshift
If in is before 7:00pm up to 3:00am Night Shift

Patulong sir_
Thank you
 
Re: MS excel we give solutions. formula, codes and tutorials

tim mckey said:
Boss Knives645,

Thank you sa Formula.
ok poh yung result pero di na madistinguish kung night shift or day shift.

If in is before 7:00am up to 3:00pm Dayshift
If in is before 7:00pm up to 3:00am Night Shift

Patulong sir_
Thank you
Click to expand...

Konting experiment using IF and Logical OR, I came up with...
Code: 
=IF(OR((HOUR(G25) >= 19), (HOUR(G25) <= 3)), "NIGHT", "DAY")
 
Re: MS excel we give solutions. formula, codes and tutorials

knives645 said:
Konting experiment using IF and Logical OR, I came up with...
Code: 
=IF(OR((HOUR(G25) >= 19), (HOUR(G25) <= 3)), "NIGHT", "DAY")
Click to expand...

thank you bro. di ko napansin agad na meron pala post. salamat sa pagsagot. :thumbsup: :thumbsup: :thumbsup: :thumbsup:
 
Re: MS excel we give solutions. formula, codes and tutorials

Sir Knives/Sir kirby,

Thank you ulhet sir,

Mayroon pa sir, may previous formula kc aq na ginagamit to determined late, and undertime.
nong ginamit q na yong format ng time di na niya mcompute ng tama.

Late (Dayshift)
7:06am - 7:15am = less half hour late
7:16am - 8:00am = 1 hour late
8:01am - 9:00am = 2 hour late
9:01am - 11:00am = 4 hour late
11:01am - 4:00pm = 8 hour late

Late (Nightshift)
7:06pm - 7:15pm = less half hour late
7:16pm - 8:00pm = 1 hour late
8:01pm - 9:00pm = 2 hour late
9:01pm - 11:00pm = 4 hour late
11:01pm - 4:00am = 8 hour late

Undertime (Dayshift)
3:59 PM - 3:30 PM = less half hour undertime
3:29 PM 3:00 PM = 1 hour undertime
2:59 PM 2:30 PM = 2 hour undertime
2:29 PM 2:00 PM = 3 hour undertime
1:59 PM 1:30 PM = 4 hour undertime
1:29 PM 11:00 AM = 8 hour undertime

Undertime (Night Shift)
3:59 AM - 3:30 AM = less half hour undertime
3:29 AM 3:00 AM = 1 hour undertime
2:59 AM 2:30 AM = 2 hour undertime
2:29 AM 2:00 AM = 3 hour undertime
1:59 AM 1:30 AM = 4 hour undertime
1:29 AM 11:00 PM = 8 hour undertime
 

Attachments

  • Payroll Sample2.rar
    15.7 KB · Views: 14
Re: MS excel we give solutions. formula, codes and tutorials

Please use HOUR() to extract hour from a certain date and MINUTE() to extract minutes, and use IIF() to check statement.

That's all you need to fulfill your last request. Enjoy! Thanks!
 
Re: MS excel we give solutions. formula, codes and tutorials

tim mckey said:
Sir Knives/Sir kirby,

Thank you ulhet sir,

Mayroon pa sir, may previous formula kc aq na ginagamit to determined late, and undertime.
nong ginamit q na yong format ng time di na niya mcompute ng tama.

Late (Dayshift)
7:06am - 7:15am = less half hour late
7:16am - 8:00am = 1 hour late
8:01am - 9:00am = 2 hour late
9:01am - 11:00am = 4 hour late
11:01am - 4:00pm = 8 hour late

Late (Nightshift)
7:06pm - 7:15pm = less half hour late
7:16pm - 8:00pm = 1 hour late
8:01pm - 9:00pm = 2 hour late
9:01pm - 11:00pm = 4 hour late
11:01pm - 4:00am = 8 hour late

Undertime (Dayshift)
3:59 PM - 3:30 PM = less half hour undertime
3:29 PM 3:00 PM = 1 hour undertime
2:59 PM 2:30 PM = 2 hour undertime
2:29 PM 2:00 PM = 3 hour undertime
1:59 PM 1:30 PM = 4 hour undertime
1:29 PM 11:00 AM = 8 hour undertime

Undertime (Night Shift)
3:59 AM - 3:30 AM = less half hour undertime
3:29 AM 3:00 AM = 1 hour undertime
2:59 AM 2:30 AM = 2 hour undertime
2:29 AM 2:00 AM = 3 hour undertime
1:59 AM 1:30 AM = 4 hour undertime
1:29 AM 11:00 PM = 8 hour undertime
Click to expand...

sir, pag aralan mo to, parang malapit nato sa ina asam mo.hehehe... http://office.microsoft.com/en-001/excel-help/introduction-to-vlookup-RZ101862716.aspx?section=2
 
You must log in or register to reply here.

Similar threads

R
Please Help me datagridview rearange
Replies
0
Views
376
rapsoyso09
R
&watag
Excel Visual Basic Application
Replies
4
Views
2K
walo
walo
N
Data entry to other workbook excel vba
Replies
2
Views
671
neil1188
N
God love us
For Excel VBA expert only
Replies
0
Views
615
God love us
God love us
Patch2012
Excel VBA Incrementing Code [HELP]
Replies
4
Views
624
arcajx
arcajx
Back
Top Bottom