Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create formula to sum hours & min's
I need help, my feeble mind cannot come up with a formula to match my 60 min
time clock. I need to have a "form" that other employees can just plug the #'s in and not have to mess with the formula or the numbers (ie: going from a 60 min clock to an 100 min clock) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create formula to sum hours & min's
Get them to input the time as hh:mm, and then just add them together. Format
the result cell as [h]:mm. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Susan" wrote in message ... I need help, my feeble mind cannot come up with a formula to match my 60 min time clock. I need to have a "form" that other employees can just plug the #'s in and not have to mess with the formula or the numbers (ie: going from a 60 min clock to an 100 min clock) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create formula to sum hours & min's
What does the plugged #s look like ? Is it real time, as in
08:45 ? Or is it 8.45 or 8.75 or 845 or all of the above ? You may want some theory on this first http://www.cpearson.com/excel/datetime.htm Best wishes Harald "Susan" skrev i melding ... I need help, my feeble mind cannot come up with a formula to match my 60 min time clock. I need to have a "form" that other employees can just plug the #'s in and not have to mess with the formula or the numbers (ie: going from a 60 min clock to an 100 min clock) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create formula to sum hours & min's
They are entering the time as 8.45
"Harald Staff" wrote: What does the plugged #s look like ? Is it real time, as in 08:45 ? Or is it 8.45 or 8.75 or 845 or all of the above ? You may want some theory on this first http://www.cpearson.com/excel/datetime.htm Best wishes Harald "Susan" skrev i melding ... I need help, my feeble mind cannot come up with a formula to match my 60 min time clock. I need to have a "form" that other employees can just plug the #'s in and not have to mess with the formula or the numbers (ie: going from a 60 min clock to an 100 min clock) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create formula to sum hours & min's
With 8.45 in A1, formula in B1 converts to real time:
=TIME(INT(A1),MOD(A1,1)*100,0) HTH. Best wishes Harald "Susan" skrev i melding ... They are entering the time as 8.45 "Harald Staff" wrote: What does the plugged #s look like ? Is it real time, as in 08:45 ? Or is it 8.45 or 8.75 or 845 or all of the above ? You may want some theory on this first http://www.cpearson.com/excel/datetime.htm Best wishes Harald "Susan" skrev i melding ... I need help, my feeble mind cannot come up with a formula to match my 60 min time clock. I need to have a "form" that other employees can just plug the #'s in and not have to mess with the formula or the numbers (ie: going from a 60 min clock to an 100 min clock) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |