OK> I have searched but not sure I am seeing what I need or understanding it.
Simply stated I have a multiple column client tracker with a column for time in military time, then I have a total hours column. I need to know how to calculate the total hours column simply by putting in the time.
Time (column B) Hours (column G)
1500-1545 want this to calculate .75
1600-1630 want this to calculate .50
I have tried a few things but I get zero since excel sees the time range as 1500 minus 1545 etc.
TIA
Bookmarks