Excel Sheet with Custom Date/Time Formulas
Budget: $10 – $30 CAD
I need a new Excel sheet with custom formulas to handle date and time.
Requirements:
- Recognize a cell value's date/time (format: YYYY/MM/DD HH:MM)
- Subtract 2 hours from that time
-Display that value in another cell
-If no value is entered, the corresponding cell that subtracts 2 hours should not show a value of -02:00
- Check if the adjusted time falls between a starting and ending date/time in other cells
- If it does, change the entire row to yellow and font to red
-Display results in an appealing graphical output
Ideal Skills:
- Proficiency in Excel, especially with formulas and conditional formatting
- Experience with date/time manipulation in Excel
Initial data will be less than 50 rows.
Requirements:
- Recognize a cell value's date/time (format: YYYY/MM/DD HH:MM)
- Subtract 2 hours from that time
-Display that value in another cell
-If no value is entered, the corresponding cell that subtracts 2 hours should not show a value of -02:00
- Check if the adjusted time falls between a starting and ending date/time in other cells
- If it does, change the entire row to yellow and font to red
-Display results in an appealing graphical output
Ideal Skills:
- Proficiency in Excel, especially with formulas and conditional formatting
- Experience with date/time manipulation in Excel
Initial data will be less than 50 rows.