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?
|