Changing time hh:mm:ss field

[akhlaq768]

I’m currently working on time (hh:mm:ss) field.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I currently have 3 fields: - <o></o>
<o> </o>
Time Out (populated)<o></o>
Time In (populated)<o></o>
Total Time (empty)<o></o>
<o> </o>
The Total Time field is worked out by Time Out less (minus) Time In.<o></o>
<o> </o>
=SUM(AZ2-AW2)<o></o>
<o> </o>
I’ve noticed that when the time goes over the 24hr (<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:time Hour="12" Minute="0">12pm</st1:time>) I get an error, so I use the following<o></o>
<o> </o>
=SUM(AZ2-AW2)+1<o></o>
<o> </o>
What I need is to show it in hours – i.e. “<st1:time Hour="4" Minute="15">04:15:00</st1:time>” should be shown as 4.25 hours<o></o>
<o> </o>
Is this possible? And how?<o></o>
<o> </o>
Thanks in advance<o></o>

 

[Andrew Poulsom]

Try the formula:

=(AZ2-AW2+(AZ2 < AW2))*24

formatted as General.

 

[paulrm906]

Or you could just format your cell with
[h]:mm:ss
and that would show you the total hours between to given times.

Paul