I need .5 instead of .3 on total time on time sheet

[Guest]

I need to make the total time at the end of the week show .5 (39.5 hours)
not .3 (39.3 hours)

 

[Niek Otten]

What formula? What value of the source cells? What formatting?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Don Guillett]

try
=MROUND(F2,0.5)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html#time