Timesheet helper: how long was I at each location?

  • 1
  • Idea
  • Updated 2 years ago
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

Every week when filling out my timesheet I log into the dashboard to see when I arrived at work and when I left each day. I'd like "time at location" shown between the end of each trip and the beginning of the next (or in a daily summary) to make timesheets easier to fill out.
Photo of Mike H

Mike H

  • 102 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Amy

Amy

  • 68,970 Points 50k badge 2x thumb
Hi, Mike. So I asked our engineering team about this because I had a feeling you might be able to get what you want by exporting your data from the Web Dashboard to Excel and then setting up some calculations there. Or even by using IFTTT to get the data automatically into a spreadsheet and then apply the calculation. I got a few answers:
Engineer #1: Use the difference of two times as a spreadsheet formula. https://support.office.com/en-us/article/Add-or-subtract-units-of-time-9a6558a1-a86b-41d4-b244-1000fc7d31e9#bm3

Engineer #2: I think a spreadsheet would work - http://webapps.stackexchange.com/questions/22657/how-do-i-calculate-a-time-delta-in-my-google-spreadsheets

Engineer #3: Yes, Excel and even google docs have excellent date time delta functions. So they could use IFTTT with Automatic to put the trip end in a spreadsheet and then apply a delta with some formulas from the google sheets documentation, which is pretty decent.

I hope that helps!

This conversation is no longer open for comments or replies.