Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Timesheet functions
Hi all,
Tis the New Year and I now have to keep a detailed timesheet (lucky me!). Our timesheets have to be in unit form, where one unit equals 6 minutes. So far, i have the simple formula below...but don't know how to write the formula for D1. Minimum unit has to be 1, and any fraction of a unit is rounded up. Make sense? A1 start time (09:00) B1 end time (09:30) C1 total time (B1 - A1 = 00:30) D1 unit equivalent (?) Thanks for any help, Luc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Functions | Charts and Charting in Excel | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
Advise on Pivot Table & Functions | Excel Discussion (Misc queries) | |||
DSUM and other functions on External data | Excel Discussion (Misc queries) | |||
Timesheet Problem | Excel Discussion (Misc queries) |