Maven4Champ
Board Regular
- Joined
- Jun 10, 2004
- Messages
- 57
Ok, what I am trying to do is this:
My time fields in my spreadsheet are a decimal format. I need to divide each individual cell by 86400 to convert it to a seconds decimal format. Then my Access data format of hh:nn:ss will take care of the rest.
I currently am using an IIf function in another time conversion for an hourly field. I want to know if I can use an IIf function to do the statement above on these other fields and if so, what might it look like?
In Excel, I simply divide the columns of data by 86400. What way would I do a similar function like this within Access?
My time fields in my spreadsheet are a decimal format. I need to divide each individual cell by 86400 to convert it to a seconds decimal format. Then my Access data format of hh:nn:ss will take care of the rest.
I currently am using an IIf function in another time conversion for an hourly field. I want to know if I can use an IIf function to do the statement above on these other fields and if so, what might it look like?
In Excel, I simply divide the columns of data by 86400. What way would I do a similar function like this within Access?