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!
Hello po..do you have a time and motion spreadsheet na i can use to observe and perform activities?
--- I was helped na po! yey thank you Sir!
Good day mga excel masters! tanong ko lang kong pwede to. bale may tatlo akong criteria. tapos under sa isang criteria may mga pending. gusto ko sana na nka .vba xa. 1 click lang ng button at i fifilter na nya yung mga blank/pending cells. screenshot provided thanks!
View attachment 1179952
maraming salamat sa thread na 'to TS. ngayon ko lang nalaman na may ganitong thread pala dito
gusto po sanang magpatulong sa current excel project ko. gusto ko pong i plot or graph yung mga task per worker.
as if automatic nang mag fi fill yung duration based sa time started.
more power po sa thread na to!
- - - Updated - - -
pa share naman po. need ko rin po yang ganyang spreadsheet. thanks
@burtkocaine
hindi ba mas maganda gawin yan sa msproject?
Gantt chart yan eh
edit: heto, link ng tutorial sa excel
https://www.smartsheet.com/blog/gantt-chart-excel
@ amirsinghsingh
yes sir need ko po automatic makukulayan kapag nag input ka ng time start at time end
Conditional formatting sir:
View attachment 1184045
cell H2 contains formatting formula:
=AND(H$1>=$D2,H$1<=$E2)
then drag right and down
see attached file.
Sorry mga kasymb sa late reply
Mga masters Question..
Meron akong naka-attached na workbook.
Gusto ko sana marandomize column D sa "Accounts Tab" per associate sa Column I same sheet.
Pero dapat equally distributed yung Total workload sa "Intenal" tab.
alam ko sisiw lang sa inyo to.. thanks ng madami..
Anyone here interested working as Reports Analyst? Please do send me an email @ [email protected]. company: Shearwater Health
hahaha. same here need 2 report analyst. sales and merchandising knowledge is a plus.
PS: report analyst lang talaga. di mo need magbenta. (baka kasi sa nakakita ng sales baka isipin kailangan din magbebenta)