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?

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?

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?

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?

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?

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?

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?

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?