Forum Discussion
Ma_Arivazhagi
Jun 11, 2024Copper Contributor
Time Format
hello all,
I had entered a number 6 in a cell and choose the time format.
instead of instead of showing me the time as 6:00 am it gives with the date and time together!
can i know the mistake i made pls.
i am trying to schedule some work in a regular basis using the time. How do i go about to get only 6:30 am or 6:00 pm, etc.
thank u in advance to one and all
3 Replies
Sort By
Excel stores times as numbers, to be more precise as fractions of 1 day = 24 hours. so for example 6:00 am is stored as 6/24 = 0.25.
If you enter 6 in a cell, it is interpreted as 6 days, not as 6 hours.
You must enter the time as 6:00 (or as 6:0, that will be accepted too)
- Ma_ArivazhagiCopper Contributorgot it already. anyway thanks. but u didn't give the correct solution
What was the correct solution?