Time and data calculations

  • Hi,


    What would be the correct formula or VBA code for total hours calculations.
    If we had a meeting started on 1st Nov2016 at 6pm and finished 7.36 and then continued again next day. For example,[TABLE="width: 627"]

    [tr]


    [td]

    Date

    [/td]


    [td]

    Start

    [/td]


    [td]

    Suspend

    [/td]


    [td]

    Date

    [/td]


    [td]

    Reconvene

    [/td]


    [td]

    Finish

    [/td]


    [td]

    Total Hours

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]1/11/2016[/TD]
    [TD="align: right"]6:20:00 p.m.[/TD]
    [TD="align: right"]7:36:00 p.m.[/TD]
    [TD="align: right"]2/11/2016[/TD]
    [TD="align: right"]9:34:00 a.m.[/TD]
    [TD="align: right"]11:54:00 a.m.[/TD]
    [TD="align: right"]???
    [/TD]

    [/tr]


    [/TABLE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!