Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
trouble2
Constraint Violating Yak Guru
267 Posts |
 Posted - 2010-05-18 : 15:25:21
|
| Hi, I want to make a table to track time spent on the work I do.So I thought I'd do:BudgetHours intBudgetMinutes intWorkedHours intWorkedMinutes intHoursLeft intMinutesLeft intSince I cannot think of an easier way to do this, or am I wrong? |
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2010-05-18 : 17:00:05
|
| I gues no one knows an easier way...The secret to creativity is knowing how to hide your sources. (Einstein) |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-18 : 18:40:44
|
You may just keep the total time spent in minutes rather than in Hours & Minutes, you can convert from minutes to hours & minutes easily.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-18 : 18:40:47
|
You may just keep the total time spent in minutes rather than in Hours & Minutes, you can convert from minutes to hours & minutes easily.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2010-05-19 : 05:03:46
|
| That's a good sugestion, thanks!! |
|
|
|
|
|
|
Hours and minutes only