Also while I am here maybe someone could help me make an easier way to do this maybe a pre defined formula on the sheet. Say I got A1,A2, and A3 for cells. A4 is to display the total amount of hours work.
Such as A1 = 12:00PM-5:00PM A2 = 2:00PM-8:00PM A3 = 8:00AM-4:00PM Therefore A4 should display 19 Hours I would use =SUM(DATEDIFF( but the issue is The two things variable I would use would be in the same table cell. So anyone know an easy way or would I need to make a script? Also does google script work with javascript? I ask because any functions I try to use from the google script API keeps coming up as "Invalid" or "Undefined" functions. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
