Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
Hi
When adding for example overtime I format the cells to be [h]:mm and this will add beyond 24 hours. However for any value over 24 hours the formula bar displays a date even though the totals add up with the correct result. How do I change this to show in date format. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes
You can't change what the formula bar says. But, its really just a different
way of looking at data. 70 minutes = 1 hr, 10 min = 1:10 AM = 1/0/1900 1:10 AM If the formula bar displaying a date really bothers you, you can hide it via Tools-Options-View. -- Best Regards, Luke M "Phippsy" wrote in message ... Hi When adding for example overtime I format the cells to be [h]:mm and this will add beyond 24 hours. However for any value over 24 hours the formula bar displays a date even though the totals add up with the correct result. How do I change this to show in date format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up hours and minutes | Excel Discussion (Misc queries) | |||
Adding minutes to hours/minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Adding hours and minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) |