Hello all. In the excel i attach there is a number which corresponds to a duration in seconds. For instance Cell A2 is a 30 second duration shown as 30:01:00 where 30 corresponds to seconds and 01 corresponds to milliseconds.
I would like to write a formula that will sum the duration in Cell B16 in min format. For instance in this case the sum of seconds is 338.5. How can i make it show the sum as 5 mins, 38 seconds and 5 milliseconds.
What you are showing is 30 hours and 1 minute. You'd need to divide by 3600 (60 * 60) to reduce that down to seconds. Then use Custom Format ss.000.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Re: Number Format
maybe like this
duration duration DFT Total Seconds 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:09.40 0.00:00:09.40 0.00:00:09.40 0.00:00:09.40 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:09.40 0.00:00:09.40 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:30.01 0.00:00:09.40 0.00:00:09.40 Total
full duration format is: d.hh:mm:ss.ff
- d: Number of days.
- hh: Number of hours, between 0 and 23.
- mm: Number of minutes, between 0 and 59.
- ss: Number of seconds, between 0 and 59.
- ff: Fraction of seconds, between 0 and 9999999
Last edited by sandy666; 03-19-2023 at 08:07 AM. Reason: corrected
Perfect.Thanks so much!!!!
You are welcome
if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks