[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

[MikeTheBike]

Originally Posted by 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

Hi

On the basis that if AZ is always the next day if it is before AW (ie not the day after or day before !?) then try this

=(AZ2-AW2+IF(AZ2<AW2,1,0))*24

The cell with this formula should be formatted as a number (2 dec places)

HTH


MTB