I am working on a spreadsheet, and I have a cell where I have calculated a total number of hours.
the output of the calculation is 43.81 (hours). If I try and format this to hours (hh:mm:ss) it displays 19:33:20
If I change the formula to display hours - add "/24" at the end of the formula, it displays 1.826 (days), which then reverts to 19:48:53 when formatted as hh:mm:ss.
If I copy the formula cell, and Paste/Values, they still format as 19:33:20/19:48:53 rather than reverting to 43:48
format as
[H]:mm
then it will display over 24hrs
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Keeps changing to [h]:mm and then shows as 1051.10Originally Posted by etaf
a sample would help here
see yellow banner
so i have taken
43.81 in cell A1
then in B1
=A1/24
which gives in general format
1.825416667
formatted to [H]:MM:SS
43:48:36
Last edited by etaf; 02-17-2023 at 09:55 AM.
Sorry, example is attached. It is Column W where I have the issue, so not sure if it the way that all of the formulas are running
i dont see the example you gave
if i change what io think are time cells , and /24 and then format [H]:MM:SSthe output of the calculation is 43.81 (hours). If I try and format this to hours (hh:mm:ss) it displays 19:33:20
If I change the formula to display hours - add "/24" at the end of the formula, it displays 1.826 (days), which then reverts to 19:48:53 when formatted as hh:mm:ss.
this is what I get
But as its not the same as your original question - Not sure what results you expect, in the cells
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks