microsoft excel training - Time analising

Hi Debbie

Try custom formats

Right click on your cell and choose Format Cells then choose the Custom category. There are several minute and time related formats so you may need to experiment to find the right one. For example dd/mm/yyyy hh:mm allows you to specify a date and time. You can then calculate across day periods.

Hope this helps - let us know if you have further questions.

Kind regards,

Andrew