A timesheet grid you fill in like Excel
Updated on · Capalane
In short. Capalane's timesheet grid is driven from the keyboard like a spreadsheet: arrow keys, selection with Shift, F2, Delete, Enter and Tab, undo and redo, pasting from Excel. Totals recalculate as you type and each cell saves itself in under a second.
Teams stick with the workbook for a simple reason: entry is fast. Capalane keeps that speed and removes the rest: the copies to merge, the broken formulas, the cell overwritten by a colleague.
Spreadsheet gestures
- Navigation: arrow keys, Enter and Tab; Shift + arrow keys to extend the selection; Ctrl/Cmd + A to select everything.
- Editing: type directly in the cell or press F2 to edit; Delete to clear a selection.
- Undo, redo: Ctrl/Cmd + Z and Ctrl/Cmd + Y, over the last hundred actions.
- Copy and paste: a range copied in Excel pastes into the grid, and the other way round.
- Fill my week and copy-down: to carry an entry forward without retyping it.
A context menu lists these actions, and the shortcut help stays displayed below the grid.
Values are checked, never blocking
Time is entered in days, in steps of 0.25 day, with a comma or a full stop. A cell for the week accepts 0 to 5 days. A rejected value (0.3 day, a negative number, 6 days) shows its reason in the cell and is not saved: entry carries on in the other cells.
Automatic saving, even offline
Each change goes to the server a few hundred milliseconds after you type, batched with its neighbours. If the connection drops, changes wait in the browser and resume when the network returns. There is no "Save" button to forget and no version to merge.
From week to day
The grid is filled in by the week; Capalane then spreads the value from Monday to Friday. Contributors who prefer to detail their days do so in My day, and the two views stay consistent. An overrun is flagged, never silently refused.
For the method: track time entries by project and by resource.
Frequently asked questions
Can I paste data copied from Excel?
Yes. A range copied in Excel pastes into the grid as it is (tab-separated format). Each value is checked: a rejected value shows its reason in the cell, and the others are saved.
In what unit is time entered?
In days, in steps of 0.25 day: 0.5, 0,5 or 1.25 are accepted, with a comma or a full stop. A cell for the week ranges from 0 to 5 days.
What happens if the connection drops during entry?
Changes not yet sent are kept in the browser and resume when the connection returns. Nothing is lost or saved twice.
Track your projects and resources in one place
Capalane calculates capacity with public holidays and leave, collects time in a grid that types like Excel and produces reports by project, by PI and by person.
Discover Capalane