Calcualting and Adding Time Values in Exc 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trevor Aiston - 12 Oct 2007 12:16 GMT

I have a worksheet which I can correctly add/subtract time vaues. But
whenever I try and add/sum reults I do not get the answer in either hrs or
hours and mins
see below
Week    Day    Date    Start    End    HOURS
40    1    01/10/2007    08:30:00    16:30:00    08:00
40    2    02/10/2007    08:30:00    16:30:00    08:00
40    3    03/10/2007    08:45:00    16:30:00    07:45
40    4    04/10/2007    08:30:00    16:00:00    07:30
40    5    05/10/2007    09:00:00    15:00:00    06:00    1.55
                    13:15:00

Any advice guidance apprecaitted

Reply to this Message

Bob Flanagan - 12 Oct 2007 13:16 GMT

To format as delta time in hours:minutes, use

[h]:m

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

>I have a worksheet which I can correctly add/subtract time vaues. But
> whenever I try and add/sum reults I do not get the answer in either hrs or
[quoted text clipped - 9 lines]
>
> Any advice guidance apprecaitted

Reply to this Message

Rate this thread: