Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am currently dealing with an Access database that tracks activity management data for my staff. The system outputs the results of a query to Excel that details the first record entered onto the system, and the last record entered as time values with format "HH:MM:SS" - I then subtract the lowest value (TimeL) from the highest (TimeH) to give me an indication of the time users spent at work (TimeDiff). However, when I try to add the TimeDiff values together to give a total number of hours, I get an odd value - all I'm looking to do is total the number of hours together. Is there an easy way to do this? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time - How do you see if a time value is between 2 values? | Excel Discussion (Misc queries) | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Fun with Time values | Excel Discussion (Misc queries) | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Time Values | Excel Discussion (Misc queries) |