hhhh:mm:ss format

pprakken

New member
Local time
Today, 09:41
Joined
Aug 25, 2010
Messages
2
Hello,

I am trying to show the hhhh:mm:ss format in access, however it remains withint the 24 hours limit. when I try [h]:mm:ss.

I read here that you need a conversion formula for this. Can someone tell me what this is?

Thanks,

Peter
 
Hello,

I am trying to show the hhhh:mm:ss format in access, however it remains withint the 24 hours limit. when I try [h]:mm:ss.

I read here that you need a conversion formula for this. Can someone tell me what this is?

Thanks,

Peter

Peter welcome to the forum,

Within Access when you want to show time with minutes etc you would use

dd (A variety to show day as digits (dd) , abbrevations (ddd) and in full (dddd)
hh (Hours)
nn (Minutes, not like Excel which would be mm)

You should also be able to find the code in the help system
 
Hi,

Well yes I figured that out that minutes are nn.

But still in excel you have the format: [h]:mm:ss
This will give 46:12:34 as result for example 46 hours, 12 minutes and 34 seconds.

In access you can enter the format: [h]:nn:ss but it does not work it would show as result of the same time: [23]:12:34

24:01:10 would be shown as [00]:01:10

If you leave the format hh:mm:ss it would be the same only without the []
 
Access cannot display more than one day in a time format. The value can be stored but it will be held as a number of days for the integer section and a time (fraction of a day) in the decimal section.

46 hours, 12 minutes and 34 seconds stored in datetime format will show as 31/12/1899 10:12:34 PM. (Access day zero is 30/12/1899). The actual value stored is a real number 1.9253935

Values more than 24 hours for display must be calculated and constructed from parts as a string.
 

Users who are viewing this thread

Back
Top Bottom