Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Time analising
Resolved · Low Priority · Version Standard
Debbie has attended:
Excel Intermediate course
Excel Advanced course
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???????
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
|
|
Excel tip:Trace Dependents / Precedents without the blue arrowsRather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula. |
TrustScore
4.9
/ 5
2078 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.11 secs.
