Hiya
i have a Flexi Sheet i am working on. Its built in Excel 2003.
i have one problem, if a user clocks up over 24:00 hours worth of flexi the clock shows 0:00, or where user should have 25:00, it shows 1:00.
i know this is because of the 24 hour clock, but is there a way of it adding up as 24:00, then 25:00, then 26:00, and still work its way backwards the same?
the only code i have in the box is the Sum
=SUM(I10,I13:I43)
format is set on time.
if VBA code needs to be added, could this be explained step by step?
i know how to right click on Tab show code, and thats it.
Please help xxxxxxxxxxxxxxx
i have a Flexi Sheet i am working on. Its built in Excel 2003.
i have one problem, if a user clocks up over 24:00 hours worth of flexi the clock shows 0:00, or where user should have 25:00, it shows 1:00.
i know this is because of the 24 hour clock, but is there a way of it adding up as 24:00, then 25:00, then 26:00, and still work its way backwards the same?
the only code i have in the box is the Sum
=SUM(I10,I13:I43)
format is set on time.
if VBA code needs to be added, could this be explained step by step?
i know how to right click on Tab show code, and thats it.
Please help xxxxxxxxxxxxxxx
