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 |
#2
|
|||
|
|||
Hi Luc,
=ROUNDUP(C1*48,0) -- HTH RP (remove nothere from the email address if mailing direct) "Luc" <luc2_at_agostini.org wrote in message ... 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 |
#3
|
|||
|
|||
Hi Bob,
I tried that, but it gives the following... start 09:00 end 09:30 total 00:30 unit equiv 1 Luc "Bob Phillips" wrote in message ... Hi Luc, =ROUNDUP(C1*48,0) -- HTH RP (remove nothere from the email address if mailing direct) "Luc" <luc2_at_agostini.org wrote in message ... 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 |
#4
|
|||
|
|||
=ROUNDUP(C1*1440/6,0)
Luc wrote: Hi Bob, I tried that, but it gives the following... start 09:00 end 09:30 total 00:30 unit equiv 1 Luc "Bob Phillips" wrote in message ... Hi Luc, =ROUNDUP(C1*48,0) -- HTH RP (remove nothere from the email address if mailing direct) "Luc" <luc2_at_agostini.org wrote in message ... 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 |
#5
|
|||
|
|||
Hi Luc,
Sorry, I rounded to 30 mins not 6. Try =ROUNDUP(C1*240,0) -- HTH ------- Bob Phillips "Luc" <luc2_at_agostini.org wrote in message ... Hi Bob, I tried that, but it gives the following... start 09:00 end 09:30 total 00:30 unit equiv 1 Luc "Bob Phillips" wrote in message ... Hi Luc, =ROUNDUP(C1*48,0) -- HTH RP (remove nothere from the email address if mailing direct) "Luc" <luc2_at_agostini.org wrote in message ... 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 |
#6
|
|||
|
|||
excellent!
thanks a lot for you help. Luc and thank you Aladin as well "Bob Phillips" wrote in message ... Hi Luc, Sorry, I rounded to 30 mins not 6. Try =ROUNDUP(C1*240,0) -- HTH ------- Bob Phillips "Luc" <luc2_at_agostini.org wrote in message ... Hi Bob, I tried that, but it gives the following... start 09:00 end 09:30 total 00:30 unit equiv 1 Luc "Bob Phillips" wrote in message ... Hi Luc, =ROUNDUP(C1*48,0) -- HTH RP (remove nothere from the email address if mailing direct) "Luc" <luc2_at_agostini.org wrote in message ... 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 |
Reply |
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) |