R
Ron
Please need HELP. I wrote this what was supposed to be a simple spread
sheet
to track time at work. I wrote simular on years ago in 123 cant
remember how,
probably different in Excel anyway. Two problem's:
1.Example times i input in the A3 B3 C3 Cells work exept when going
over the
midnite 00:01 then it dosent work until it hits the 12:00 on duty mark
then it
works again. 23:00 05:00 05:00 F3 says i worked over the 12hr. on duty
limit.
23:30 11:00 12:00 works F3 says 01:00 Over.
2.Example The sheet has 45 rows i want to calculate totals for D3 E3
F3 on the
bottum for each of the colums. I've read about [h]:mm and applied it
to all colums well, the whole sheet. Only the F3 colum calculates
correct and will go
over 24:00. D3 and E3 come up with six digit numbers followed by :00
(14112:00).
I tried formating the sells with different propertys ([hh]:mm) nothing
seems to
work. I dont understand why F3 works and the other two dont formulas?
Out of my league...
__A3______B3_____C3______D3_______E3_____F3_______G3____
On Duty Relvd Relsd Total OD Total Over 12:00
__8:00____20:00___21:00_________________________________
Data I input
Formulas:
D3 =(B3+24)-A3 returns--12:00
E3 =(C3+24)-A3 returns----------13:00
F3 =IF(E3>12,E3-G3,E3-D3) returns------01:00
G3 Just a reference number dont know another way to do it.
Thanks in advance for any input...
sheet
to track time at work. I wrote simular on years ago in 123 cant
remember how,
probably different in Excel anyway. Two problem's:
1.Example times i input in the A3 B3 C3 Cells work exept when going
over the
midnite 00:01 then it dosent work until it hits the 12:00 on duty mark
then it
works again. 23:00 05:00 05:00 F3 says i worked over the 12hr. on duty
limit.
23:30 11:00 12:00 works F3 says 01:00 Over.
2.Example The sheet has 45 rows i want to calculate totals for D3 E3
F3 on the
bottum for each of the colums. I've read about [h]:mm and applied it
to all colums well, the whole sheet. Only the F3 colum calculates
correct and will go
over 24:00. D3 and E3 come up with six digit numbers followed by :00
(14112:00).
I tried formating the sells with different propertys ([hh]:mm) nothing
seems to
work. I dont understand why F3 works and the other two dont formulas?
Out of my league...
__A3______B3_____C3______D3_______E3_____F3_______G3____
On Duty Relvd Relsd Total OD Total Over 12:00
__8:00____20:00___21:00_________________________________
Data I input
Formulas:
D3 =(B3+24)-A3 returns--12:00
E3 =(C3+24)-A3 returns----------13:00
F3 =IF(E3>12,E3-G3,E3-D3) returns------01:00
G3 Just a reference number dont know another way to do it.
Thanks in advance for any input...