Latest activity
-
shamimarita reacted to DaOrks's post in the thread [Solved] Looking at a Column with multiple Occurrences of a Value, pulling a # value from each occurrence and adding them together with
Like.
Disregard, I am dumb. SUMIF is your friend, i got way to locked into LOOKUP functions. -
shamimarita reacted to DaOrks's post in the thread [Solved] Looking at a Column with multiple Occurrences of a Value, pulling a # value from each occurrence and adding them together with Like.
Good morning! Hopefully my question makes sense but I've got two pictures below to assist. Essentially the first image is in a sheet...
-
DDaOrks replied to the thread [Solved] Looking at a Column with multiple Occurrences of a Value, pulling a # value from each occurrence and adding them together.Disregard, I am dumb. SUMIF is your friend, i got way to locked into LOOKUP functions.
-
DDaOrks posted the thread [Solved] Looking at a Column with multiple Occurrences of a Value, pulling a # value from each occurrence and adding them together in Excel Formulas.Good morning! Hopefully my question makes sense but I've got two pictures below to assist. Essentially the first image is in a sheet...
-
-
shamimarita replied to the thread [Solved] Time-in and Time-out.Hello Shin, You can achieve this time in and time out using Google Apps Script. Barcode Scanner: Use a USB barcode scanner...
-
SI need help creating a program in which you can someone's id (with a barcode) and it automatically places it in the google sheet with...
-
shamimarita replied to the thread [Solved] Create Leave Tracker in Excel - Date to Day.Hello Rona, You must use the custom format to format the date to show only the day. Select the date cell >> Format Cells >> Custom >>...
-
-
shamimarita replied to the thread [Solved] Converting Time Durations to Excel Usable Format.You are most welcome. I'm glad to hear that it worked perfectly. Keep helping each other in the forum to make the community stronger.
-
shamimarita reacted to JOGEC's post in the thread [Solved] Converting Time Durations to Excel Usable Format with
Love.
Thank you Shamima! This worked perfectly for what I was trying to do. -
JJOGEC replied to the thread [Solved] Converting Time Durations to Excel Usable Format.Thank you Shamima! This worked perfectly for what I was trying to do.
-
RI've just started to use the "How to create leave tracker in Excel" (with easy steps) guide. The formula for inserting the day of the...
-
shamimarita replied to the thread [Solved] Converting Time Durations to Excel Usable Format.Hello Jogec, You can use the following formula: =IF(ISNUMBER(SEARCH("h", A2)), LEFT(A2, SEARCH("h", A2) - 1) * 60, 0) +...
-
-
shamimarita replied to the thread [Solved] Question about conditional counting.You are most welcome. Thanks for your feedback and appreciation. Keep helping each other.
-
shamimarita reacted to jznance's post in the thread [Solved] Question about conditional counting with Love.
This is wonderful! Thank you so much for your help. I was able to get them to work. This will hopefully streamline the incoming tardy...
-
AAkram Hassan replied to the thread I want help in creating a program like the one in the picture to calculate the lines related to the pivot points.تم حساب الانحدار المتحرك والانحدار العكسي بناءً على سعر الافتتاح لليوم الحالي. ويمكن استنتاج المعادلات المستخدمة.
