Prev: CONVERT HOURS AND MINUTES TO INT
Next: Conditional format to change row colour
From: ijustlivehere on 24 May 2010 11:48
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?
From: Roger Govier on 24 May 2010 12:37
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?
 | 
Pages: 1
Prev: CONVERT HOURS AND MINUTES TO INT
Next: Conditional format to change row colour