Date & time calculations and I/O

Do you know of a way to skip holidays on a date calculation?

Use NETWORKDAYS(start_date,end_date,holidays)

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

Does SpreadsheetConverter support date calculations?

Yes.

You can see an example below, were we build the date using Excel's date function and substract the values.

http://www.spreadsheetconverter.com/manual/date_dropdown_lis t.htm

SpreadsheetConverter will convert the date calculations into JavaScript.

I have a dropdown list with dates but SpreadsheetConverter shows 37000,37001,... ?

SpreadsheetConverter cannot handle dates in dropdown lists.

Instead use DATE to build a date. See

http://www.spreadsheetconverter.com/manual/date_dropdown_lis t.htm

What is your recommendation for TIME data entry -- e.g. time in and time out?

Use 24 hour clock, or if 12 hour clock is very important, use 2 fields one for 0-11 and a dropdown list for AM/PM and use TIME().

Or you can use TIME to build time values, for an example see

http://www.spreadsheetconverter.com/manual/date_dropdown_lis t.htm

To output date, use date formats, for example 'hh:mm'