How to format number of hours and minutes in Access 2013

[Apple08]

Hi all

I am new to Access. I need to format hours and minutes in Access and then having a value in the Excel Pivot Table. For example 30 hours 40 minutes should be input as 30:40.

I tried Date/Time, numbers or even short text with input Mask 00:00, but they don't turn out the same format after export to Excel Pivot Table, it showed as 3040 a whole number.

Please could anyone help. The format is flexible, I just want to show how many hours and minutes, and turns out a value for pivot graphic. Any suggestions are welcome.

Many thanks.

 

[ranman256]

The date field wont work that way
so store it as text, and parse in/out the min/secs if you need to.
BUT
if you store [starttime] and [endTime] as date fields THEN you can get it as:
DateDiff("n", [start], [EndTime]) \ 60 & ":" & ((DateDiff("n", [StartTime], [EndTime])/60) -(DateDiff("n", [StartTime], [EndTime]) \ 60))*60

 

[Apple08]

Thanks very much!