Function to count clock reaching 24 hours

V

Veronica

I am in the process of making a dive chart to monitor that amount of time
spent in the water etc and am in need of help. I have my time spent being
summed up in one cell but need to put another function in another cell to
count the clock reaching 24 hours each time. The sum itself reverts back to
zero once 24 is reached but I need to count each time it reached 24. Any
ideas???
 
S

Sheeloo

If you are adding up time in Cell A1 and format the cell as a number then the
integer part of the value will give you number of times it has reached 24

If you don't want to disturb Aq then enter this in B1
=INT(A) and format as a number...

Excel stores time in fractions with 1 corresponding to 24 hours... so if you
enter decimal 0.5 and format it as time (hh:mm) you will get 12:00
 
S

Shane Devenshire

Hi,

If your cell that totals the hours is in A1 then format A1 to the custom
format D - choose Format, Cells, Number tab, Custom and enter d in the Type
box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

24 Hour Clock Calculations 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
time diffrence with 24 hour clock 3
Data Validation when entering hours over 24 8
time calculations 1
how do I calculate a week days hours with the 24hour clock 5
function to add time totals over 24 hours 2
Time Greater Than 24 Hours 3

Top