Posted to microsoft.public.excel.worksheet.functions
|
|
Adding date/time in format dd/mm/yyyy hh/mm
http://www.cpearson.com/excel/DateTimeWS.htm
--
Regards,
Peo Sjoblom
"DaveAsh" wrote in message
...
I am struggling to subtract a start date/time cell from a finish date/time
cell. I can do it using the =sum function, but this gives the total hour
difference. I need to change this to working hours (those hours between
9&5),
any ideas??
Thanks
|