A adrianbarnes.com May 10, 2006 #1 Hey, anyone know an easy way to have Excel add 12 business hours (M-F, 8:00 - 4:30) to current date/time? Thanks
Hey, anyone know an easy way to have Excel add 12 business hours (M-F, 8:00 - 4:30) to current date/time? Thanks
R Reid_at_work Joined Jun 5, 2006 Messages 3 Reaction score 0 Jun 5, 2006 #2 Do you want to record time based on a 24 hour clock? I do not know how to "program" Excel to do that automatically: I just enter my time (worked) in the format of HH.MM, with a 2 decimal place holder.
Do you want to record time based on a 24 hour clock? I do not know how to "program" Excel to do that automatically: I just enter my time (worked) in the format of HH.MM, with a 2 decimal place holder.
