Time Formula?

[Praefect]

I have a log i am trying to make to help keep track of time a I spend working on a website or onlthe computer for that matter. The problem is i cannot get a time formula to work correctly

Date description t/start t/end use code total/t daytot/t
7-Sep sort files 8.25 10.55 MNT
7-Sep ntzrolo 10.55 10.58 SRV


cumtot/t

I need total elapsed time for each line total/t then daytot/t is the cumulative times of line 2, line 3 and so on.
cumtot/t is the total of each line in housrs and minutes. my prob is that no matter what i have tried 61 minutes will not show as 1 hour and 01 minutes.

Any suggestions/ideas? or is this even possible?

[VBA Noob]

Hi,

Deduct End - Start time. Format cell as HH:MM.

Cell doing sum format as [H]:MM.

More help from the attached website

http://www.cpearson.com/excel/datearith.htm

VBA Noob

[Praefect]

Thanks for the help and the link, much appreciated

Hi,

Deduct End - Start time. Format cell as HH:MM.

Cell doing sum format as [H]:MM.

More help from the attached website

http://www.cpearson.com/excel/datearith.htm

VBA Noob