# Thread: Changing time hh:mm:ss field

1. Registered User
Join Date
Oct 2007
Posts
127

## Unanswered: Changing time hh:mm:ss field

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?

2. Registered User
Join Date
Apr 2004
Location
Derbyshire, UK
Posts
805
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?

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•