Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Time analising
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training - Time analising
Resolved · Low Priority · Version Standard
Reply Thu 12 Jul 2007, 15:56Delegate Debbie said...
Debbie has attended:
Excel Intermediate course
Excel Advanced course
Time analising
How can i analise data that starts at 22:00hrs and goes through to say 03:00am and the answer be correct over data falling in two time periods???????
For upcoming training course dates see: Pricing & availability
RE: 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
|