Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert time to 1/4 hours
I have created a spreadsheet for keeping track of work hours. I have a
calculation already for hours worked but need to be able to convert 7:45 to 7.75, 6:15 to 6.25, 5:30 to 5.5, etc... We are only allowed those three additions (.25, .5, .75) to whole numbers. Tried the dividing by 24 thing... not the answer I need. Columns a time in, time out, total hours (which is what needs to be converted). Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert time to 1/4 hours
Hi
Tried the dividing by 24 thing... not the answer I need Did you try multiplying by 24 and formatting as general? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "lktx" wrote: I have created a spreadsheet for keeping track of work hours. I have a calculation already for hours worked but need to be able to convert 7:45 to 7.75, 6:15 to 6.25, 5:30 to 5.5, etc... We are only allowed those three additions (.25, .5, .75) to whole numbers. Tried the dividing by 24 thing... not the answer I need. Columns a time in, time out, total hours (which is what needs to be converted). Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert time to 1/4 hours
I didn't change the formatting to number... then it worked fine. Oops.
Thanks!! "Mike H" wrote: Hi Tried the dividing by 24 thing... not the answer I need Did you try multiplying by 24 and formatting as general? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "lktx" wrote: I have created a spreadsheet for keeping track of work hours. I have a calculation already for hours worked but need to be able to convert 7:45 to 7.75, 6:15 to 6.25, 5:30 to 5.5, etc... We are only allowed those three additions (.25, .5, .75) to whole numbers. Tried the dividing by 24 thing... not the answer I need. Columns a time in, time out, total hours (which is what needs to be converted). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert a summed time value to hours only | Excel Discussion (Misc queries) | |||
How do I convert more than 24 hours time to decimal? | Excel Discussion (Misc queries) | |||
How do I convert time listed in hours(e.g. 170:41:19) to seconds? | Excel Worksheet Functions | |||
convert military time to regular hours | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |