Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
In a timesheet, I'd like to be able to do a calculation for the hours worked,
then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
Helen,
Try this where C1 is the hours worked, drag down as required:- =(C1-INT(C1))*24 Mike "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
Just use
=C1*24 and format as general or number -- Regards, Peo Sjoblom "Mike H" wrote in message ... Helen, Try this where C1 is the hours worked, drag down as required:- =(C1-INT(C1))*24 Mike "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
As long as the timing does not go through midnight..........
=(B1-A1)*24 Vaya con Dios, Chuck, CABGx3 "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
Sorry; should have been more explicit.
Col A = 08:30 Col B = 15:00 Col C = SUM(a2-a1) = 6:30 = 6.5 In other words, I want to do a circular type calculation where I do the SUM calculation followed by the c1*24 calculation, with the answer ending up in Column C. Any chance of accomplishing that? "Peo Sjoblom" wrote: Just use =C1*24 and format as general or number -- Regards, Peo Sjoblom "Mike H" wrote in message ... Helen, Try this where C1 is the hours worked, drag down as required:- =(C1-INT(C1))*24 Mike "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
Why are you even using SUM, B2-A2 is sufficient, so
=(B2-A2)*24 important that you change the format to general or number or else it will display in a time format don't know what you mean by a2-a1 since the end time is in B? -- Regards, Peo Sjoblom "Helen" wrote in message ... Sorry; should have been more explicit. Col A = 08:30 Col B = 15:00 Col C = SUM(a2-a1) = 6:30 = 6.5 In other words, I want to do a circular type calculation where I do the SUM calculation followed by the c1*24 calculation, with the answer ending up in Column C. Any chance of accomplishing that? "Peo Sjoblom" wrote: Just use =C1*24 and format as general or number -- Regards, Peo Sjoblom "Mike H" wrote in message ... Helen, Try this where C1 is the hours worked, drag down as required:- =(C1-INT(C1))*24 Mike "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
What equation do I use if my time goes past midnight?
"CLR" wrote: As long as the timing does not go through midnight.......... =(B1-A1)*24 Vaya con Dios, Chuck, CABGx3 "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Hours to Decimal
Hi Helen
Try =MOD(B1-A1,1)*24 -- Regards Roger Govier ijustlivehere wrote: What equation do I use if my time goes past midnight? "CLR" wrote: As long as the timing does not go through midnight.......... =(B1-A1)*24 Vaya con Dios, Chuck, CABGx3 "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, then convert it to decimal. Column A - Start Time Column B - End Time Column C - Hours Worked Col A = 08:30 Col B = 15:00 Col C = 6:30 = 6.5 Is there such a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add hours and show actual hours not decimal numbers | New Users to Excel | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
converting a decimal number to hours and seconds | Excel Worksheet Functions |