how to convert a time to minutes

[hashinimoses]

hi

I have a time field in short time format and I want it to convert to minutes and add a time in minutes for it and calculate the total time in hours and minutes. can anyone help me?

[twinnyfo]

Hashinimoses,

Welcome to Bytes!

The simplest method I can think of is to use the DateAdd() Function, using “n” as the interval. You can review all teh syntax in this MS Office Article.

Hope this hepps!

[NeoPa]

HashiniMoses:
I have a time field in short time format

No. You really don't. You have a Date/Time field (Full stop). How it's formatted when you display it is no part of this question. It's simply confusing you into thinking about it the wrong way.

So, you have a Date/Time value, that presumably has no date component, and you'd like to add x number of minutes to that. You may even desire to show the result as a Time (in Short Time) format.

Of course TwinnyFo is on exactly the right lines. I wanted to try to ensure you not only got an answer, but that you also let go of the wrong-thinking that caused you to be confused in the first place.

So, assuming the variable you start with is datVar, and the number of minutes you want to add is intVar, then you could say :

datVar = DateAdd("n", intVar, datVar)

To display this as a Short Time (Be careful as this is modulo so won't show correctly if the value exceeds 24 hours.) :

Debug.Print Format(datVar, "HH:nn")