# Hh:mm field

**URL:** https://forums.knack.com/t/hh-mm-field/15501
**Category:** Get Answers
**Created:** [January 10, 2024, 3:41pm UTC](https://forums.knack.com/t/hh-mm-field/15501 "2024-01-10T15:41:19Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Ralph](https://avatars.discourse-cdn.com/v4/letter/r/f475e1/32.png) [@Ralph](https://forums.knack.com/u/Ralph)
#### Post date: [January 10, 2024, 3:41pm UTC](https://forums.knack.com/t/hh-mm-field/15501/1 "2024-01-10T15:41:19Z")

</div>

Hi,

I have a csv I need to import where several columns contain time data in terms of hours and minutes, it can be 10:24, or 78:11 or even 178:02, so it is not ending at 24:00

With these hours I need to to do calculations later on, basically sum and average.

I am struggling to find the correct field type for these data, if I use date/time or timer it converts the data to something strange and if I use simply text I can not do any calculations with it.

Any help is highly appreciated