Latest activity
-
shamimarita replied to the thread 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 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.تم حساب الانحدار المتحرك والانحدار العكسي بناءً على سعر الافتتاح لليوم الحالي. ويمكن استنتاج المعادلات المستخدمة.
-
Jjznance reacted to shamimarita's post in the thread [Solved] Question about conditional counting with
Like.
Hello Jznance, Thank you for your question! You can achieve this in Excel using a combination of COUNTIF or COUNTIFS formulas to track... -
Jjznance replied to the thread [Solved] Question about conditional counting.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...
-
JJOGEC replied to the thread [Solved] Converting Time Durations to Excel Usable Format.Hello Shamimarita, Thank you for your response. I tried to use the formula, but it appears to only work when the seconds are in the...
-
shamimarita replied to the thread [Solved] Question about conditional counting.Hello Jznance, Thank you for your question! You can achieve this in Excel using a combination of COUNTIF or COUNTIFS formulas to track...
