Excel calculation of duration in hours and minutes
The standard functions in excel allow to calculate duration in hours
and minutes, using the format hh:mm for the result. However; hh:mm is normally used only for clocktime: any duration of more than 23:59 will start again from 00:00, whilst the result could be any figure (24:00; 168:00, ...). Does Excel provide a solution? |
Excel calculation of duration in hours and minutes
Format as [h]:mm rather than hh:mm
Steve On Fri, 09 Feb 2007 15:11:49 -0000, wrote: The standard functions in excel allow to calculate duration in hours and minutes, using the format hh:mm for the result. However; hh:mm is normally used only for clocktime: any duration of more than 23:59 will start again from 00:00, whilst the result could be any figure (24:00; 168:00, ...). Does Excel provide a solution? |
Excel calculation of duration in hours and minutes
Yes it does. Try a custom format of [hh]:mm
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk wrote in message ups.com... The standard functions in excel allow to calculate duration in hours and minutes, using the format hh:mm for the result. However; hh:mm is normally used only for clocktime: any duration of more than 23:59 will start again from 00:00, whilst the result could be any figure (24:00; 168:00, ...). Does Excel provide a solution? |
Excel calculation of duration in hours and minutes
Great, it works! Thanks for the turbo response. May I add a
complication? The difference between scheduled time and actual time (Time A - Time B) can also be negative: however, excel does not allow a negative time-value... Or does it? |
Excel calculation of duration in hours and minutes
Tools/ Options/ Calculation/ 1904 date system
But if you do that, be careful if you are trying to transfer dates to and fro with spreadsheets set up with the conventional 1900 system. -- David Biddulph "Esbee" wrote in message oups.com... Great, it works! Thanks for the turbo response. May I add a complication? The difference between scheduled time and actual time (Time A - Time B) can also be negative: however, excel does not allow a negative time-value... Or does it? |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com