var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Changing time hh:mm:ss field
Im 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.
Ive noticed that when the time goes over the 24hr (12pm) I get an error, so I use the following
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
Originally Posted by akhlaq768
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
The cell with this formula should be formatted as a number (2 dec places)