Changing time hh:mm:ss field

[akhlaq768]

I’m currently working on time (hh:mm:ss) field.

I currently have 3 fields: -

Time Out (populated)
Time In (populated)
Total Time (empty)

The Total Time field is worked out by Time Out less (minus) Time In.

=SUM(AZ2-AW2)

I’ve noticed that when the time goes over the 24hr (12pm) I get an error, so I use the following

=SUM(AZ2-AW2)+1

What I need is to show it in hours – i.e. “04:15:00” should be shown as 4.25 hours

Is this possible? And how?

Thanks in advance

[arthurbr]

Hi,
when total time is larger than 24 hr
right click the cell
select format
select number tab
select custom and select format [h]:mm:ss

To change to 04:15:00 to decimal value, multiply by 24 and format the result as number
Cheers

[oldchippy]

Hi,

Try this

=(MOD(AZ2-AW2,1)-INT(MOD(AZ2-AW2,1)))*24 format to number