Time spreadsheet

[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

 

[Cindy Conover]

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

 

[Roger Govier]

Hi Cindy

=IF($B26="b",($D26-$C26)*24,"")

 

[Cindy Conover]

Thanks, worked perfect

Cindy

Hi Cindy

=IF($B26="b",($D26-$C26)*24,"")