Advertisement
Guest User

Untitled

a guest
Dec 15th, 2021
37
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. function onEdit(e) {
  2. if (e.range.columnStart != 2) return; // if it's not column B do nothing
  3.  
  4. var date = e.range.getValue();
  5.  
  6. if (date.getFullYear() < 1990) {
  7. const [h,m,s] = ['Hours','Minutes','Seconds'].map(s => date[`get${s}`]());
  8. e.range.setValue(new Date(new Date().setHours(h,m,s,0)));
  9. }
  10.  
  11. e.range.setNumberFormat('hh:mm am/pm');
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement