Time spreadsheet

  • Thread starter Thread starter Cindy Conover
  • Start date Start date
C

Cindy Conover

A B C D E F G H I J K L M N O
Date Line Start End RO Outside Internal Super. Training Property Shop LineDaily Monthly Time Time Number Labor Labor & Equip Maint Clean Up Labor Labor Labor
out Int A B C D E02/02/09 B 10:27 15:04 96554 0.19?4.62 0.19
INT 15:04 17:52 96598 0.12?2.80 0.31 B 18:22 19:04 96554 0.03?.70 0.34
INT 19:04 19:34 96598 0.02?.50 0.36 INT 19:34 23:12 96606 0.15?3.63 12.25? 0.51 0.51 0.51


In the above example I fill in columns A-E. The rest of the columns are
filled in by formulas. The problem is that the populated (?) times do not
add correctly. the numbers with the arrows by them are there to tell you
what the numbers should be. How do a format my cells to correctly total
time? I know the time uses 2 different formats but that is the way our time
clock (on work computer) totals for the day.

TIA

Cindy
 
That did not copy well sorry, how about this I know if I have time adding in
columns I can do the formula example =d1*24 to get the correct amount in
decimals.

So 10:27 to 15:04 gives me 4.62 not .19. but the spreadsheet already has
the following formulas in the columns that do not add correctly.
=IF($B26="b",($D26-$C26),"") how do I add the =d1*24 to my preexisting
formulas?


Cindy
 
Back
Top