software

Im trying to do a simple fomula, to add a lunch time to a monthly stat if
they have done more than 6 hours

The time is in the format 08:45:00 - meaning 8 hours 45 mins

but im trying to put a formula in which reads =IF(a1gt;06:00:00,00:45:00,0)
this i was hopeing would put 45 mins into a cell if they have worked more
than 6 hours that day. but it doesnt work.

Can anyone help please.

try IF(A2gt;0.25,quot;00:45:00quot;,0)
because the general or number format gives the value of 06:00:00 as 0.25quot;Timquot; wrote:

gt; Im trying to do a simple fomula, to add a lunch time to a monthly stat if
gt; they have done more than 6 hours
gt;
gt; The time is in the format 08:45:00 - meaning 8 hours 45 mins
gt;
gt; but im trying to put a formula in which reads =IF(a1gt;06:00:00,00:45:00,0)
gt; this i was hopeing would put 45 mins into a cell if they have worked more
gt; than 6 hours that day. but it doesnt work.
gt;
gt; Can anyone help please.

Thanks

Easy when you know how. Quick responsequot;flow23quot; wrote:

gt; try IF(A2gt;0.25,quot;00:45:00quot;,0)
gt; because the general or number format gives the value of 06:00:00 as 0.25
gt;
gt;
gt; quot;Timquot; wrote:
gt;
gt; gt; Im trying to do a simple fomula, to add a lunch time to a monthly stat if
gt; gt; they have done more than 6 hours
gt; gt;
gt; gt; The time is in the format 08:45:00 - meaning 8 hours 45 mins
gt; gt;
gt; gt; but im trying to put a formula in which reads =IF(a1gt;06:00:00,00:45:00,0)
gt; gt; this i was hopeing would put 45 mins into a cell if they have worked more
gt; gt; than 6 hours that day. but it doesnt work.
gt; gt;
gt; gt; Can anyone help please.